discountopk.blogg.se

Spreadsheet libreoffice
Spreadsheet libreoffice











Once you're finished, you should have an output.csv file that you can open in LibreOffice. Why 15 items? Because it seems like you have 15 rows of data per column Otherwise, ignore the lineĮvery 15 items added this way, introduce a new line ( \n) to the output.

spreadsheet libreoffice spreadsheet libreoffice

If there's a leading number, append it ( \g) to the output, along with a single comma ( ,). Loop through each and every line and use regular expressions ( import re at the beginning) to check if the line has a leading number (off the top of my head it should be something like r"^(\d+).+") csv file out of your original textfile, open it up in LibreOffice and copy+paste it into your existing table.Ĭreate a new blank file, called output.csv or whatever Off the top of my head, it seems easier to create a.













Spreadsheet libreoffice