dilshod / xlsx2csv

Convert xslx to csv, it is fast, and works for huge xlsx files
MIT License
1.68k stars 303 forks source link

Define which columns and rows to process in a tab #219

Open toolbox1972 opened 3 years ago

toolbox1972 commented 3 years ago

Sometimes, very often, one have more data in Excel then wanting to export. It could be description or any other text string. If having a feature that lets the user select which columns and rows to process in a tab, one could keep the metadata in excel but only export selected columns and rows in the processed tab.

It would be good to be able to either just add single columns or rows, but also ranges, e.g column: B-D, or lines: 1-4, 6-21. I attached an example where one would only want to export B2:C3, since rest are controls and profit that should not end up in the result CSV.

xlsx2csv_select_area_to_export