Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Importing multiple html tables into XL?
Greetings XL experts.
I have about 20 html tables with about 100 rows and 5 columns. I want to set them up in Excel and apply simple formulas to do some processing. Only three of the columns are useful and two of them could be combined. The final result would be about 20 sets of two columns in Excel and a final column that contains the summed data. Can anyone suggest a process that would make this as simple as possible? In case of intense curiousity ;-) this program would calculate my daily nutrient intake. I have not been able to find a simple program to do this. I found several but most were antiquated DOS or had mainly listings of very processed foods which I avoid. The USDA has a very good web site that list the nutrients in many foods but they didn't go that most useful step further - to make it usable for 3 or more meals i.e a day's nutrient intake. If anyone already has such a program, I'd be delighted. TIA rf |
#2
|
|||
|
|||
You can navigate through an HTML website programmatically using the Document
Object Model, OR, programmatically adjust the data after the import/copy has occurred. http://HelpExcel.com "RedFox" wrote: Greetings XL experts. I have about 20 html tables with about 100 rows and 5 columns. I want to set them up in Excel and apply simple formulas to do some processing. Only three of the columns are useful and two of them could be combined. The final result would be about 20 sets of two columns in Excel and a final column that contains the summed data. Can anyone suggest a process that would make this as simple as possible? In case of intense curiousity ;-) this program would calculate my daily nutrient intake. I have not been able to find a simple program to do this. I found several but most were antiquated DOS or had mainly listings of very processed foods which I avoid. The USDA has a very good web site that list the nutrients in many foods but they didn't go that most useful step further - to make it usable for 3 or more meals i.e a day's nutrient intake. If anyone already has such a program, I'd be delighted. TIA rf |
#3
|
|||
|
|||
Thanks galimi.
I don't understand your answer but will check your link. rf "galimi" wrote in message ... You can navigate through an HTML website programmatically using the Document Object Model, OR, programmatically adjust the data after the import/copy has occurred. http://HelpExcel.com "RedFox" wrote: Greetings XL experts. I have about 20 html tables with about 100 rows and 5 columns. I want to set them up in Excel and apply simple formulas to do some processing. Only three of the columns are useful and two of them could be combined. The final result would be about 20 sets of two columns in Excel and a final column that contains the summed data. Can anyone suggest a process that would make this as simple as possible? In case of intense curiousity ;-) this program would calculate my daily nutrient intake. I have not been able to find a simple program to do this. I found several but most were antiquated DOS or had mainly listings of very processed foods which I avoid. The USDA has a very good web site that list the nutrients in many foods but they didn't go that most useful step further - to make it usable for 3 or more meals i.e a day's nutrient intake. If anyone already has such a program, I'd be delighted. TIA rf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple worksheets in html - one file | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
Autofiltering multiple tables on a spreadsheet | Excel Worksheet Functions | |||
importing multiple text files URGENT!!! HELP | Excel Worksheet Functions | |||
Importing French (Canadian) format html pages | Setting up and Configuration of Excel |