csv2odf Activity
csv2odf can convert csv data to formatted spreadsheets and documents.
Brought to you by:
w322
Activity for csv2odf
-
Philip Stanford posted a comment on discussion Using csv2odf
Hi Larry thanks for such a quick response! Glad to be able to report that the new version of the package installs without any errors. Regards Phil
-
Larry Jordan posted a comment on discussion Using csv2odf
Phillip, Thanks for that info. It looks like there was a dependency error in the deb package, it should have depended on the python3 package. I have uploaded a new package (csv2odf_2.10-2.deb). You can test at you convenience. Let me know if that does not fix it. Thanks, Larry
-
csv2odf released /csv2odf-2.10/csv2odf-2.10-2.tar.gz
-
-
-
I've previously used version 2.09 of this very useful package on an older Debian system. I'm now trying to install it on a Raspberry Pi 4 running Debian 11.10 ('Bullseye'). I'm aware that version 2.10 requires Python 3 - which I have, but the installation is failing as below: # ls -l /usr/bin/python lrwxrwxrwx 1 root root 7 Mar 2 2021 /usr/bin/python -> python3 # python --version Python 3.9.2 # dpkg -i csv2odf_2.10-1.deb Selecting previously unselected package csv2odf. (Reading database ... 53432...
-
Main_Page
-
John, I removed Python 2 support because my current OS (Debian 12) does not have it preinstalled, which leads me to think not many people are using it for new installs of csv2odf. Removing Python 2 support also helps with testing because in the past (back in 2017) I tested on both Python 2 and 3, and I would prefer to just test on 3. Thanks you! Larry
-
jrw32982 posted a comment on ticket #13
Thanks for your quick update, Larry. I noticed that you changed several other things, besides the fixes I found. Was that just to use "better style" for python 3 or was that related to other bugs that you had found earlier? Or some other reason? I just left a review. I like your design, which reduces complication and gets the job done well. Thanks!-- John On Friday, February 23, 2024 at 10:14:40 PM EST, Larry Jordan <w322@users.sourceforge.net> wrote: Thank you for this bug report. The program has...
-
Larry Jordan committed [b4ead8] on Code
Release 2.10.
-
Larry Jordan committed [bd8e8e] on Code
Updates to wide and long test scripts.
-
Larry Jordan committed [2be721] on Code
Replaced additional variable type instances.
-
Larry Jordan committed [02a8f6] on Code
Removed obselete code.
-
Larry Jordan committed [eb3e57] on Code
Removed Python 2 variable types.
-
Larry Jordan committed [ceebd5] on Code
Dropped support for Python v2.x.
-
Larry Jordan committed [60a583] on Code
Test script updates.
-
Larry Jordan committed [f0d31d] on Code
Changes for compatibility with Python 3.11
-
csv2odf Version 2.10 has been Released
-
cgi.escape() not found
-
Thank you for this bug report. The program has not received attention for a while and Python changes caused the problems you found. The program has been updated and version 2.10 has been released. Thank you. Larry Jordan
-
-
-
-
-
cgi.escape() not found
-
You may need to run like this: ./csv2odf If that does not work, try running with python in front: python csv2odf
-
You may need to run like this: ./csf2odf If that does not work, try running with python in front: python csv2odf
-
LakshmiPriya posted a comment on ticket #12
hi Larry, I have tried to run the below command, but getting "csv2odf: Command not found" error. csv2odf -H file.csv sample.xlsx output.xlsx
-
unable to install csv2odf
-
Changes to Excel Template Absolute References
-
It looks like you have successfully installed csv2odf, it displays a help screen if no parameters are provided. Please see the documentation for instructions, but here is the basic syntax: csv2odf options csvfile templatefile outputfile I hope it works well for you. Thanks. Larry
-
FYI, my Linux box has python 2.7
-
unable to install csv2odf
-
Javier Bazan posted a comment on discussion Using csv2odf
Hi Larry! I apologize for the delay in getting back to you, work has been keeping me very busy. Just wanted to let you know that your workaround works perfectly! After adding "null" on row #2 the formatting is kept. I can successfully see my template in both Libre Office and Microsoft Office. Thanks a lot!! (owe u beer!) Cheers
-
Thank you Larry! Finishing some work now and I will test this either today or tomorrow. Will get back to you with the results. Best regards,
-
Javier, I recieved your template. The only problem I see is that you need some sample data on the second row. I know it is not obvious why it is necessary, but the way the spreadsheets work is if a cell is empty it is compressed down in a way that csv2odf has nothing to grab on to. So what you need is some dummy data, it can be simple like a zero where a number goes, or the letter A where some text will go. That will create an "instance" of the cell with formatting applied. Csv2odf will take that...
-
I will look into it. Office is more particular about having everything coded perfectly, whereas LibreOffice will allow some variances. Thanks. Larry
-
As always Larry, thank you for taking the time of building and maintaining this great tool! Was creating some new reports and for the first time tested the results in Office 2016 (I've been always using Libre Office) and realized that with Microsoft's product the format is lost after the csv content is dumped into the xlsx template. Libre Office: everything is fine, the final xlsx file has the header, font, size, centered, etc (so it preserves the entire formatting that I defined on my xlsx template)....
-
czbg posted a comment on discussion Using csv2odf
Hi Larry, thank you very much for your response. It worked! I thought I've tried that... Best regards
-
Hi, The program has been designed to expand a range in a formula so that it will point to all the inserted rows. If that is not what you want, would it work to add the cells like =B2+C2+D2 instead of using the sum function? Thank you. Larry
-
Hi, thank you for this great program. I have a csv like this: C1,C2,C3,C4,C5,C6,C7,C8 bla,,,,,0.015,,184.434 bla1,3,,55,,12,2,,184.434 In template, I have the same first two rows. Just that I have in 9th and 10th column formulas like =SUM(B2:D2) and =SUM(E2:H2) When file is generated, all formulas are like =SUM(B2:D11) and =SUM(E2:H11) 11 is the first empty row. Why this changes when file is generated? Please help. Thank you and BR
-
Great. Glad it worked.
-
sai-mike posted a comment on discussion Using csv2odf
Tested with my log files - works great. Thanks for making that addition.
-
Main_Page
-
Main_Page
-
Main_Page
-
Larry Jordan committed [6aac86]
Add --csv-encoding option.
-
Larry Jordan committed [85a628]
Updates to testing.
-
Larry Jordan committed [5f3a78]
Release 2.09
-
Larry Jordan committed [6a2fba]
Packaging version 2.09
-
Version 2.09 is released. Get it here: https://sourceforge.net/projects/csv2odf/files/csv2odf-2.09/ This version has a new option, --csv-encoding, which allows you to specify the encoding of the csv file. Please test and if find any problem, you can reply here or enter a bug report. Regressions related to unicode handling are possible.
-
sai-mike, You can try version 2.09. It has the new option --csv-encoding. You would use it like --csv-encoding=utf-16le. Let me know if it does not work as expected. Thanks. Larry
-
-
-
-
Great! We deal with a lot of equipment that is manufactured in Asia and it seems to use utf-16 for internal logging to support asian language text. If csv2odf can process that character set then that is one less conversion I need to automate in going from raw log files to business reports.
-
Currently the program does not support that encoding. It is a use case I had not thought of. I am going to research the possibility of adding an option to specify csv file encoding.
-
I am trying to convert log files from an industrial device to .ods spreadsheets. If I run file -i on the original files it reports "text/plain: charset=utf-16le" and csv2odf fails when run using the original file. I can convert a file using LibreOffice Calc to UTF-8. If I run file -i on the converted file it reports "text/plain: charset=us-ascii" and csv2odf runs fine. Is it possible to use csv2odf with utf-16le input files?
-
Rob Kinman posted a comment on ticket #11
Hi Larry The INDEX function works for my purposes (Although your code increments...
-
Rob, The program treats the absolute address the same as a regular address. What...
-
Changes to Excel Template Absolute References
-
Larry Jordan committed [0a2117]
Bugfix unicode error, filter offset.
-
Larry Jordan committed [804a11]
Packaging for version 2.08.
-
Larry Jordan committed [01d4b3]
Release 2.08.
-
Larry Jordan committed [42c451]
Debugging regression in unicode (xlsx stringfile)
-
Error handling Unicode XLSX
-
Version 2.08 is released. Get it here: https://sourceforge.net/projects/csv2odf/files/csv2odf-2.08/...
-
-
-
-
Oudiceval posted a comment on ticket #10
This version fixes the issue. Thank you!
-
Thanks for testing. I have a version attached that should fix the problem.
-
-t option on csv2odf
-
Error handling Unicode XLSX
-
Oops, I did miss that message. I had forgotten the details of the -o option, I remember...
-
Hey larry, not sure whether u saw my last message on this topic. Just checking :)...
-
Great! That change will be in version 2.07. One extra tip, with large csv files,...
-
Larry Jordan committed [c297fa]
Release 2.07
-
Larry Jordan committed [ef3236]
Bugfix for memory error with xlsx and large csv...
-
Larry Jordan committed [fc8803]
Packaging for version 2.07.
-
Version 2.07 is released. Get it here: https://sourceforge.net/projects/csv2odf/files/csv2odf-2.07/...
-
-
-
-
Great! That change will be in version 2.07. One extra tip, with large csv files,...
-
It works now with the new version! Thanks Larry !!!
-
Javier, Attached is a version you can try for the memory error. Thanks. Larry
-
Ok so just tried with v2.06 and got the same error :( csv2odf -t 1 -c ";" "$FILE_CSV1_FINAL"...
-
Ok so just tried and it worked with v2.06 but it overwrited column's A text with...
-
Ok so just tried and it worked with v2.06 but it overwrited column's A text with...
-
Ok so just tried and it worked with v2.06 but it overwrited column's A text with...
-
Ok so just tried and it worked with v2.06 but it overwrited column's A text with...
-
Ok so just tried and it worked with v2.06 but it overwrited column's A text with...
-
Good stuff Larry, I wouldn't have realized about that syntax on the -o flag. I will...
-
Thanks Larry for your quick prompt. Yes, excellent point you make about the version,...
-
Hey, I noticed you are using version 2.04, would you mind trying the latest version...
-
You can do it with the -o option. If I understand, you need to insert one data column...
-
What is supposed to happen is the output goes to a temporary file in memory, and...
-
Another one Larry. Hope I can explain it properly. I have the following template...
-
Hey Larry, Having an issue when converting a csv file that has 300.000 lines into...
1 >