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 >
