Importing HTML table to Excel - Can it bring in formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a system that is generating HTML documents with a table and then
opening them in Excel. This works just fine, Excel is converting the tables
into a spreadsheet without problem and preserving the HTML formatting.

But now I'm being asked to pass formulas into these sheets in certain places
instead of values. Is there any notataion that I can use in the HTML table to
pass a formula to Excel instead of a value?

Thanks in advance.
 
You cannot take HTML content a produce formulas out of nothing. Why not
create a second workbook with cellinks to the original Excel document?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is Paste Special HTML broken in Excel/Office 2007? 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Protecting Formulas in Tables 2
Trying to paste in text like "01" from HTML table as text not numb 3
copying HTML table into Excel 1
Importing html documents into Excel adds rows to the body. 1
Bring Excel Workbooks/Spreadsheets into SharePoint 1
Bring in Word table 2

Back
Top