Tagged Questions
1
vote
1answer
13 views
Converting xsxl into csv
I'm wondering if there is a way to convert an .xsxl file into .csv while preserving everything in its entirety.
I have a column that for some rows has values like 0738794E5 and when I convert it ...
-2
votes
0answers
14 views
Add several rows from one csv file into one row in another csv file [closed]
I need to merge two csv files.
First file has rows with product info, one product each row, there is a product number in the row.
Second file has image URLs, one URL each row. The images are product ...
0
votes
1answer
22 views
PHP / MYSQL Split XLS based on Column and Insert
I have a large excel file of ship locations for the next 2 years. Currently, I am manually splitting this file into multiple files and then importing into MYSQL. This wont work for long though, as ...
1
vote
1answer
47 views
Trying to output an answer with linq
I've been working on a program that joins two arrays by an identifier called "SeqID" and outputting an answer to a CSV file.
Whenever I output this answer to a file it prints out the same answer for ...
0
votes
1answer
44 views
Leading zero in CSV on reopen [duplicate]
I have txt file which looks like below
I am importing the txt file in excel using the method shown here. Column Account is converted to text.
Once the data is imported, file looks like below.
I ...
4
votes
0answers
55 views
Excel Cell Formatting Special Case
I have an interesting dilema and was wondering if someone might know if this is possible. I'm creating a .csv file using java and for one of the comma separated entries for each row is a url.
...
-1
votes
2answers
69 views
Delimiter in Excel
I'm having problem with finding a unique delimiter for excel when I import a bunch of data from csv. I wanted "^;" to be the unique delimiter. However, Excel isn't smart enough to know that I just ...
1
vote
1answer
297 views
Seting TextCodepage property of WorkbookSaveAsArgs (Workbook) object
Folks, I'm trying to set the TextCodepageproperty of WorkbookSaveAsArgs used as argument for an Workbook method SaveAs. Which is used to convert .xls files in .csv ones. However, this property ...
6
votes
3answers
5k views
Converting JSON to XLS/CSV in Java
Does anyone have any sample Java code to convert a JSON document to XLS/CSV file? I have tried to search on Google but to no avail.
2
votes
1answer
5k views
Importing CSV using LOAD DATA INFILE quote problem
I'm trying to get this CSV file that I exported from excel loaded into my database and I can't seem to get the formatting correct no matter what I try.
Here is the SQL:
LOAD DATA INFILE ...
18
votes
6answers
9k views
Which encoding opens CSV files correctly with Excel on both Mac and Windows?
We have a web app that exports CSV files containing foreign characters with UTF-8, no BOM. Both Windows and Mac users get garbage characters in Excel. I tried converting to UTF-8 with BOM; Excel/Win ...
14
votes
9answers
21k views
Is it possible to force Excel recognize UTF-8 CSV files automatically?
I'm developing a part of an application that's responsible for exporting some data into CSV files. The application always uses UTF-8 because of its multilingual nature at all levels. But opening such ...
6
votes
4answers
5k views
python: creating excel workbook and dumping csv files as worksheets
I have few csv files which I would like to dump as new worksheets in a excel workbook(xls/xlsx).
How do I achieve this?
Googled and found 'pyXLwriter' but it seems the project was stopped.
While Im ...
47
votes
13answers
46k views
Stop Excel from automatically converting certain text values to dates
Does anyone happen to know if there is a token I can add to my csv for a certain field so Excel doesn't try to convert it to a date?
I'm trying to write a .csv file from my application and one of the ...
87
votes
21answers
54k views
Microsoft Excel mangles Diacritics in .csv files?
I am programmatically exporting data (using PHP 5.2) into a .csv test file.
Example data: Numéro 1 (note the accented e).
The data is utf-8 (no prepended BOM)
When I open this file in MS excel is ...
