CODEWITHSUNDEEP
excelcsv
Rndm
Rndm

Reputation: 6870

writing csv to open as different tabs in Excel

Is there some way to write a csv file such that , when opened in MS Excel , it will open in different tabs in the workspace ?

Upvotes: 1

Views: 184

Answers (2)

chris
chris

Reputation: 412

csv is a continuous run of lines of values separated by commas. each line doesn't even have to have the same number of values etc. there's no concept of workbooks or different "areas" in csv. Excel cannot be cajoled into opening a csv into multiple workbooks...well at least not without writing VBA to parse the csv file yourself. the oxml or whatever they've ended up calling the xml file spec for office, allows workbooks and is still easy to deal with being text based. Do you have to use csv or can you switch (at least part way through) to xml?

Upvotes: 0

Adriaan Stander
Adriaan Stander

Reputation: 166486

The short answer is, NO.

For that matter, the long answer is NO too.

Upvotes: 3

Related Questions