XLS Generation (@vxls)

01. An editor for tables, formulas, and charts

XLS Generation opens an AI spreadsheet editor with @vxls. Prepare tables, formulas, charts, and multi-sheet changes, review their preview, then apply them. You can also open and edit existing XLSX files.

02. Start with @vxls

03. Source data and effective requests

Specify source ranges, column names, units, periods, calculations, and output locations. Distinguish real data from examples and include number formats and sheet names.

1. @vxls Create a monthly sales table with total formulas, currency formatting, and a bar chart
2. @vxls Calculate profit margins from selected sales and costs and summarize them in a new sheet
3. @vxls Create a regional pivot grouped by year and month with a connected pivot chart

04. Cells, sheets, and range selection

1. Enter an address such as B5:D12 in the name box to select a range.
2. Switch sheets with the bottom tabs and inspect values and formulas in the formula bar.
3. Use the cell, table, chart, formula, data, and formatting tools.
4. Adjust row and column sizes and number formats, then save XLSX with Ctrl/Cmd+S.

05. Selection questions and references

Select the source range and commit any active cell edit before asking. AI uses the sheet, selection, values, and formula results captured at question time. Keep the source range and insertion destination distinct.

06. Preview and apply AI work

1. Choose full insertion or partial/advanced insertion from the response.
2. Choose the current cell, below selection, replace selection, or a new sheet.
3. Review actual sheet addresses, overwrite counts, formulas, charts, and rules in the AI work preview.
4. Apply all tasks to commit the validated changes together. One undo reverses the entire operation.

07. Create and verify formulas

Use supported functions such as SUM and IFERROR and check cross-sheet, absolute, and relative references. Press F4 while entering a formula to cycle reference styles, and search function help for supported functions and examples.

08. Create and edit charts

Include source ranges, chart type, axis titles, units, and legends in the request. Use Insert → Create/edit chart to adjust types and series, and resize sheet charts with their edge handles.

09. Formatting rules, validation, and pivots

1. Conditional formatting: request threshold highlights, duplicate markers, data bars, or color scales.
2. Validation: specify lists such as In progress/Done, allowed numbers or dates, and error messages.
3. Pivots: specify source ranges, rows, columns, values, filters, and aggregations such as sum or average.
4. Set up slicers, timelines, and formula tracing through the editing menus.

10. Size limits and compatibility

AI insertion supports up to 2,000 rows and 100 columns per block, 10,000 cells overall, and 16 sheets. Review any excluded rows, cells, or features and their references, then split the work. These are AI insertion limits, not overall editor size limits.

11. XLSX, PDF, and recovery

1. Download an editable workbook with XLSX Save or Ctrl/Cmd+S.
2. PNG captures the current sheet view; PDF and print use selected ranges, used areas, or all sheets.
3. Check VORA save confirmation; download the XLSX first if saving fails.
4. Restore browser-stored drafts from File → Document recovery, and keep separate copies of important files.

12. Troubleshooting and final checks

Finish in this order: source data, calculation checks, work preview, apply all, save and reopen. Screenshot values are examples, not evidence for your own work.