deanes02 Posted August 28, 2007 Report Share Posted August 28, 2007 Hi,I have some code that creates a html table on the fly. Ideally I would like to export this table from my webpage as an excel spreadsheet. I have tried saving the table from IE as a html file and then opening that file in Excel. It displays perfectly but no matter what I seem to do (including converting the cells to number format) I can not do maths operations on the cells i.e. I can't add a list of my cells together. Am I going about it the wrong way? Perhaps there's a bit of javascript that will export the table to something excel friendly or maybe there is a way to the math operations on html tables in excel?????Please help with any suggestions. Thanks as always,SD Quote Link to comment Share on other sites More sharing options...
ɹəuəllıʍ ʇɐb Posted August 29, 2007 Report Share Posted August 29, 2007 Not sure what your problem is. Are these math operations already present in the HTML table (how?), or are they added later in the converted Excel sheet?We have some members here with pretty good Excel knowledge; just wait until they sign in (UK time). Quote Link to comment Share on other sites More sharing options...
Irene Posted August 29, 2007 Report Share Posted August 29, 2007 Hi deanes02 :) When you have downloaded, then opened in Excel, have you then done a 'Save As' an Excel file before trying to manipulate the data? If not, that may be worth a try. Quote Link to comment Share on other sites More sharing options...
deanes02 Posted August 29, 2007 Author Report Share Posted August 29, 2007 The math operations are added after the file is brought into excel. I save the file from IE doing 'save as' selecting the html only option. I then open the .htm file in excel. I convert the format of the relevant cells to number and try to add two cells together. All I get is the #VALUE! error.I did try to save the .htm as a .xls file in excel and then reopen but i get the same errors.I have attached a sample .htm file downloaded from my site.Please let me know if you need more clarification.Thanks,SDtest_report_01.htm Quote Link to comment Share on other sites More sharing options...
Irene Posted August 29, 2007 Report Share Posted August 29, 2007 In my experience, the #VALUE! error is when it is formatted as a text field.Perhaps you could try touching the top of each column, then format the whole column as a number as appropriate. i.e. whole number, decimal places etc. Quote Link to comment Share on other sites More sharing options...
deanes02 Posted August 29, 2007 Author Report Share Posted August 29, 2007 Thanks for your reply but I tried that but it does not format the cells at all. Try it on the previously attached file and you'll see what I mean. Quote Link to comment Share on other sites More sharing options...
Irene Posted August 29, 2007 Report Share Posted August 29, 2007 Thanks for your reply but I tried that but it does not format the cells at all. Try it on the previously attached file and you'll see what I mean. Sorry, but I can't interact with your attachment at all. :(Could you point me to an example of the table actually in IE which you are trying to save from?It just occurred to me that you may be including the text header, patination in the SUM formula. That is probably a basic thing to suggest, so please accept my appology in advance. Quote Link to comment Share on other sites More sharing options...
deanes02 Posted August 30, 2007 Author Report Share Posted August 30, 2007 You can see an exact example of the report at http://domain782922.sites.fasthosts.com/ex...e-report-01.htmAs an example I need to be able to save that file as it is (I know there are meant to be image etc but you ignore them) and be able to add the column Pagination.Thanks for your interest and your help! Quote Link to comment Share on other sites More sharing options...
Irene Posted August 30, 2007 Report Share Posted August 30, 2007 Phew!!! What do you think of this....The procedure I used was:On the web page - Edit - Select All - Save As a .txt file.I then opened Word, specifying 'All Files' at the bottom of the 'Open' dialogue box. This allowed me to load the table into a Word document.Now 'Insert' an Excel table into the Word dcument.Highlight the data in the table by right-click across the top of the columns (you see a small arrow pointing downwards at the top of each column.Now right-click in the centre of the table and from the small menu select copy.Next double click the inserted excel spreadsheet to activate it. Touch the top lefthand cell, right-click on the cell, then paste. The data is now in the spreadsheet.Now it is possible to add the column headed 'Pagination'. B) :D ... not sure if this may be too lengthy for your needs!! Quote Link to comment Share on other sites More sharing options...
deanes02 Posted August 30, 2007 Author Report Share Posted August 30, 2007 A good solution but unfortunately I need something a bit more dynamic i.e. save the file, open in excel, format cells and do the math. I'm finding it hard to believe IE and excel don't have a more dynamic interaction. Quote Link to comment Share on other sites More sharing options...
Irene Posted August 30, 2007 Report Share Posted August 30, 2007 I must admit, it was rather long winded!! My final suggestion is... In IE, if you go into Tools, Internet Options, Programs. The top option is to select the program which is used as HTML Editor.I have not tried this one myself.Good Luck! :D If it doesn't work, maybe someone else might have some ideas. Quote Link to comment Share on other sites More sharing options...
ɹəuəllıʍ ʇɐb Posted August 31, 2007 Report Share Posted August 31, 2007 The only other thing I can think of to suggest is news://msnews.microsoft.com/microsoft.public.excel.misc; there are regularly MVPs hanging out there. Quote Link to comment Share on other sites More sharing options...
Irene Posted September 4, 2007 Report Share Posted September 4, 2007 I was just looking at Google and came across this. I wondered if it might solve the problem..LOOK HERE Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.