Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
105,000 line XML to Excel
I have an XML with 105,000 lines. I found out how to import this into
Excel from a message on the board and a link to http://www.cpearson.com/excel/ImportBigFiles.aspx. Now I have two worksheets with the data. Currently I have this basic structure throughout the worksheets: <1 <2 <3 <4 Etc Each node is in its own column. I want to change my worksheets so every node in listed in every column. Like this: <1 <!<2 <1<2<3 <1<2<3<4 I don't want to Ctrl+D the needed nodes through 105,000 lines. Any suggestions? Thanks, Nick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
105,000 line XML to Excel
After the sheet is imported, select the columns that need data added and do
Edit=Goto=Special and select blanks Now look at what the active cell is. Assume it is A2. Goto the formula bar and enter =A1 and then do Ctrl+Enter rather than just enter. This will fill in all the data. Now reselect the entire columns and do Edit=Copy, then Edit=Paste Special and select values. this will replace the formulas with the values they contain. You might need to select data from the last row of the sheet to the top row of the next sheet (so the top row is filled in) and then repeat and so forth. -- Regards, Tom Ogilvy " wrote: I have an XML with 105,000 lines. I found out how to import this into Excel from a message on the board and a link to http://www.cpearson.com/excel/ImportBigFiles.aspx. Now I have two worksheets with the data. Currently I have this basic structure throughout the worksheets: <1 <2 <3 <4 Etc Each node is in its own column. I want to change my worksheets so every node in listed in every column. Like this: <1 <!<2 <1<2<3 <1<2<3<4 I don't want to Ctrl+D the needed nodes through 105,000 lines. Any suggestions? Thanks, Nick |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
105,000 line XML to Excel
Thanks Tom. It works great!
Nick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
change line formatting in line chart - Excel 2007 | Charts and Charting in Excel | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
counting line by line matches of 2 columns possible in excel ? | Excel Discussion (Misc queries) | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) |