Linux Journal

Convert SpreadSheets to CSV files with Python and pyuno, Part 2

Using the SSConverter class that we developed last week, which used the OORunner class from the week before that, this week we'll create a Python function that allows us to use spreadsheets as if they ...

Can't read CSV even in Python 3.15? Practice specifying character encoding

"I updated Python, but I can't read Japanese CSV files." When you open a file you've received and see a string of English ...

CSV columns misaligned in Python? Reading product names with commas correctly

When I loaded the product names from the CSV, the quantity column contained "Black". Even though I just separated them by commas, the columns shifted halfway through. In such cases, checking if there ...
Linux Journal

Convert SpreadSheets to CSV files with Python and pyuno

Each input file is a spreadsheet and it is converted into the corresponding output file as a CSV file. As with OORunner, this code is based on PyODConverter. Next week we'll write a converter function ...