Apache Commons CSV <https://commons.apache.org/proper/commons-csv/>
talks the Excel CSV variant (amongst others - it's configurable)
Nick
On 21/04/17 22:48, Javen O'Neal wrote:
I'm guessing that an Excel CSV file is a regular CSV file that is written
in a specific dialect (quoted strings, newline character, delimiter, etc).
You could try transforming your CSV file into an Excel dialect if you knew
what this dialect was (I'm assuming the receiving website has a spec and a
file validator, either of which could be used to figure out why vanilla CSV
files are rejected).
You could try using Python's csv module to write your data in the Excel
dialect, which might be easier than a Java project.
You could also work with the website authors for a better way to exchange
data. If you need some teeth with your request, mention how their system
might have issues demonstrating compliance with HIPAA.
On Apr 21, 2017 11:04 AM, "Dominik Stadler" <[email protected]> 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 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
