Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Standard CSV File
Hello,
I am trying to save some data from Excel to a CSV file to import into an application I am working on. The problem is that I get a file with Mime: application/vnd.ms-excel Instead of: text/csv How can I create a standard text/csv file? Thank You, Miguel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Standard CSV File
"shapper" schrieb im Newsbeitrag
... Hello, I am trying to save some data from Excel to a CSV file to import into an application I am working on. Do you mean, you are programming this app? Or is it an existing app and you are just working with this app? If it's the first case, then which programming language are you using? You could probably use DAO to read the excel file directly or automate Excel to get the data from the excel file without first exporting to a CSV file. The problem is that I get a file with Mime: application/vnd.ms-excel Instead of: text/csv How can I create a standard text/csv file? Thank You, Miguel How do you save the file? Manually, selecting File, Save as ... from the menu or by code? If the latter, provide your code, so we can look at it. BTW, you _do_ know that the CSV standard isn't a standard at all? Depending on the localized version of Excel you are using, the default format Excel is using by creating a CSV file or expecting when reading a CSV file may be comma separated (in the US, UK, ...) or semicolon separated (in Germany, France, ...) Helmut. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Standard CSV File
Is the mime type a problem ? It should still open fine in your other
application. Tim "shapper" wrote in message ... Hello, I am trying to save some data from Excel to a CSV file to import into an application I am working on. The problem is that I get a file with Mime: application/vnd.ms-excel Instead of: text/csv How can I create a standard text/csv file? Thank You, Miguel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
standard deviation | Charts and Charting in Excel | |||
standard deviation | Excel Discussion (Misc queries) | |||
Standard Colors | Excel Worksheet Functions | |||
Inserting a standard row through VBA | Excel Programming | |||
File size problem: standard remedies not working. | Excel Programming |