Hi,
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,
DaveLaw
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 <sivaksrip...@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-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
