Upload a table, combine the first column with each other column to generate independent files and download them as a zip package
π« Automatically filters invalid data rowsπ Each file contains a "Historical Quotes" sub-sheet (first position)
π Original data preview (first 10 rows Β· red strikethrough = invalid rows to be filtered)
π‘ Rules: The first column is used as the common column (time) and is combined with each of the remaining columns to form a new table.
ποΈ Each file contains two worksheets (order adjusted):
π Historical Quotes: only the current data column (single column, no time column) β placed first
π Sheet1: common column + current data column (two columns) β placed second
π« Automatically filter invalid data: Rows where the current column value is 0, empty, null, or NaN will be removed; rows with an empty common column will also be filtered.
π Enhanced data detection (this optimization): No longer relies on the file's built-in dimension markers; directly scans real cells to locate the data area, fixing the issue where columns with data are split out as blank. Also supports merged cell filling, formula cached value fallback, automatic multi-worksheet selection, and GBK encoding for CSV.
π Format preservation: Date and number formats and column widths are carried into the split files (dates are written as numeric serial numbers uniformly, and Excel / WPS will display them as dates).