Please nominate your Qt Champions for 2021! https://forum.qt.io/topic/132134/looking-for-the-2021-qt-champions
Excel to QT (importing to QT)
cacahuatita last edited by
First of all, I'm not developing content really but the company I work for uses a QT based software. I work as a translator for them and I'm having a bit of a problem here.
They sent me an excel file (.CSV format) to work on...because there were many things to correct on previous translations, I'm translating from English to Spanish so special characters are a must. I converted the file to an XLSX so that I could use some filters and colors. Now they are telling me that I need to upload every change I make manually...and doing that would take an eternity.
I thought, and understood form emails and I guess just assumed, that as they could send the
Code_ReaQtor last edited by
This "link":http://qt-project.org/wiki/Handling_Microsoft_Excel_file_format will help you how to deal with excel files.
Concerning .CSV files, I have implemented a reader/parser months ago and you can find it in "QtSimplify":http://qtsimplify.blogspot.com/2013/02/dealing-with-csv-files-easy-way.html . Dealing with CSV files is a bit difficult with QString::split() or QRegExp as they violate the rules in CSV parsing so I created a different approach. I think it will maintain special characters since it was based in QTextStream and QChar, just modify it.