Oct-18-2022, 02:59 PM
This is a simple task in python
there are only 3 (4 if you make cell selection a separate line) lines of code necessary
That's it
- load the excel 'recon' sheet using pandas see: pandas.read_excel
look at examples at bottom of page.
- write pandas frame: see DataFrame.to_csv
look at attribute " sep='|' " (on same document page) to set your separator.
there are only 3 (4 if you make cell selection a separate line) lines of code necessary
- import pandas
- load the excel page
- write selected cells to the csv page
That's it