| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel chart issue - cannot include a cell in my data series | Excel Discussion (Misc queries) | |||
| issue with excel 2003 data import | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
| Importing data from Excel to Outlook | Excel Discussion (Misc queries) | |||
Threaded Mode
