View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
ExcelJockey ExcelJockey is offline
external usenet poster
 
Posts: 1
Default Importing data to excel (newline/carriage return issue)

hi Tandaina,

i'm a linux guy too. here is another plan of attack in addition the
excellent suggestions here. perhaps overkill but good for future
reference...

(using perl modules on cpan.org)

encode the data from each field into something XML friendly, parse it
into XML, then import the XML into Excel 2003

http://office.microsoft.com/en-gb/as...019641033.aspx

then unencode the data in excel. (CPAN has win32 excel modules for
manipulating spreadsheets.)

------------------------------------------------------------------------
ExcelJockey's profile: http://www.exceljockeys.com/forums/p...iewprofile&u=4
View this thread: http://www.exceljockeys.com/forums/v...c.php?t=304562