poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Law <David....@apconsult.de>
Subject Re: Java API for Excel
Date Sun, 23 Apr 2017 15:04:48 GMT

one thing was not quite clear about the original question:
do you actually need the Excel at all?
or is the sole purpose of the exercise just to generate a CSV-File for 
your upload?

And even if you do need the Excel, it would seem easier just to change the
Programme to write the CSV as a second file without having to use POI 
for that bit.

Surely, the Excel CSV-Format is just a question of using other 
delimiters between fields?
(and maybe quoting/escaping any strings containing delimiters, which is 
absolutely trivial)

All the best,

On 21/04/2017 20:04, Dominik Stadler wrote:
> Hi,
> Can you share an anonymized sample-csv-file? Apache POI likely does not
> have support for this itself, but if it is a text-format, it should be
> fairly easy to iterate over the rows/cells and produce the text-format
> yourself if we can figure out how Excel formats this CSV in some special
> way to be able to later detect the format again.
> BTW, please post such questions to the user-list, not to developers
> directly, this prevents others from participating in the documentation.
> Dominik.
> On Fri, Apr 21, 2017 at 7:45 PM, Siva Sripada <sivaksripada@gmail.com>
> wrote:
>> Hi,
>> My name is Siva Sripada and I am a physician living in Michigan. I am
>> writing a program to upload a list of patients (first name, last name,
>> birthdate) to a website that will provide me information on a patient’s
>> previous prescription history over the last 1 year.
>> I am using the Apache API for Java for Excel and the program works
>> great!!! but….The website requires that the file be in *Excel’s* CSV format
>> only. So for example the website will not take a text file with
>> comma delimiters saved as a CSV file. Nor will it accept a .xlsx that was
>> simply renamed with a .cvs file. Currently I am opening the .xlsx file
>> saved with my program thru Excel and re-saving it with Excel’s CSV format
>> - which works but does not leave me satisfied.
>> Excel’s CSV files have the unique(?) property of being able to be opened
>> by both Excel and any text editor (don’t know if that means anything to
>> you). Plus these files when opened in a text editor have comma delimiters
>> plus a carriage return at the end of each line.
>> My question is :
>> Is there a way to change the formatting of the .xlsx file thru The Apache
>> API so that it saves it as a “true” Excel CVS file?
>> Any help would be appreciated.
>> Thank you,
>> Siva Sripada

To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message