Python

how to create csv file

Please support our Python advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Jan 2008

Posts: 3

Reputation: morrison is an unknown quantity at this point

Solved Threads: 0

morrison

Offline

Newbie Poster

Re: output/write to a xls file

Jan 2nd, 2008

•

Originally Posted by Ancient Dragon

You cannot write directly to an *.xls file and expect Excel to read it because *.xls files are not plain text files -- they contain a lot of formatting information that is readable only by Excel program.

The easiest way to do it is to creates *.csv files which Excel can import. Fieids (cells) are commma or sometimes tab separated, with CR/LF between each row. Using your example you might write it like this: Text should be surrounded with quotes (see first example below)
Help with Code Tags

Python Syntax (Toggle Plain Text)
myfile << "\"Hello World\"," <<  nums[1] << "," <<  nums[2] << ","  nums[3] << "\n";
 
or
myfile << nums[1] << "\t" <<  nums[2] << "\t"  nums[3] << "\n";
myfile << "\"Hello World\"," << nums[1] << "," << nums[2] << "," nums[3] << "\n"; or myfile << nums[1] << "\t" << nums[2] << "\t" nums[3] << "\n";

Above thing is correct to write in csv but I am facing one problem to write it in csv as html editor code cannot be write as csv as it generates error on csv file writing.Due to this the only way is to write an excel file as data in html format can also be write.

Here in writing excel file I have an script which I used in writing it but while reading it using another script for excel it generates an error as mentioned below:-

"The filename shipaccountactivity1.xls is not readable"

Can u plz help me in above case as how can I write it so that it can easily be readable.......

Thanks in advance.....

•

Join Date: Aug 2005

Posts: 15,672

Reputation: Ancient Dragon has a reputation beyond repute

Solved Threads: 1502

Ancient Dragon Ancient Dragon is offline

Offline

Still Learning

Re: output/write to a xls file

Jan 2nd, 2008

Do you mean you are using an html editor to write the csv file? Then why is this question in the C board?

Don't PM me with questions -- you might get a nasty PM in response. If you have a question then post it in one of the forums.

•

Join Date: Jan 2008

Posts: 3

Reputation: morrison is an unknown quantity at this point

Solved Threads: 0

morrison

Offline

Newbie Poster

Re: output/write to a xls file

Jan 2nd, 2008

No sir,I m using php script but I m writing excel with html content as I have one field with product description.

•

Join Date: Jan 2008

Posts: 3

Reputation: morrison is an unknown quantity at this point

Solved Threads: 0

morrison

Offline

Newbie Poster

Re: output/write to a xls file

Jan 2nd, 2008

•

Originally Posted by Ancient Dragon

Do you mean you are using an html editor to write the csv file? Then why is this question in the C board?

It doesn't matter whether it is php or c post.Thing is that html code cannot be write on an csv and that's y only excel file will be written in such case and I have done it very neately.I am just going through concept and not on language........

So much thanx........