http://stackoverflow.com/a/8125708/2683399
You could use Excel to save to an Excel CSV and try to imitate the output with whatever application you write. On Apr 21, 2017 14:48, "Javen O'Neal" <one...@apache.org> 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" <dominik.stad...@gmx.at> > 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 > > > > >
