LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Excel vs .csv?

Mike pretended :
The algebraic modeler is MPL of Maximal Software. When I had the table
in Excel, you can go around the problem by adding a LHS ' to every
element whether it is number or text. Now, when I saved the Excel file
as a csv it no longer accepts an index that has some elements as
numbers while others are text (like CW)?!


Mike,
So what you're saying is that 'Excel' removes the apostrophes when
saving as CSV so that when reopening the file later the data no longer
has apostophes on the LHS?

Perhaps you need a custom import procedure that ensures the apostrophes
are placed if missing? If so.., read the entire CSV into an array and
place apostrophes where needed. If MPL reads from Excel then dump the
array into a worksheet.

-OR-
If MPL reads in from the CSV directly then dump the array back into the
CSV.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"