Yeah, by default, there's no PDF option in Office 2007 installed, but there's a free update that can be downloaded to include saving as PDF:
http://www.microsoft.com/downloads/deta … laylang=en
NathanG, if security is not an issue, you should be able to upload the .xls (or .xlsx) and simply link to it. You can either manually it to the VSD project (Settings -> Add Files) or upload it with another FTP application like DirectFTP. You'd then remember where you uploaded it, type some text, make it a link (yoursite.com/yourexcelfile.xls)
If you have a Gmail account, it also allows uploading Excel files and sharing/publishing spreadsheets. Pretty neat stuff, especially for free.
Adam R.
Ambassador
3,120 posts
Josh L
Registered User
4 posts
Your method seemed obvious once I read it. I tried it and it seemed to work (although as you say there is a lot of bloatware in there.
I asked Larry's question in private support about 2 or 3 quarters ago and did not get the same response. I think that getting spreadsheet tables into HTML is a point of frustration for some website owners. So, it is possible Coffee Cup should be doubly aware of this and maybe work out a way for coffeecup software itself to allow for pasting of spreadsheet data as a table into an html page, if it would be possible to do that. I think there is a paste-lines-as-table feature. I'm not sure if this could lead into paste-as-table feature?
I asked Larry's question in private support about 2 or 3 quarters ago and did not get the same response. I think that getting spreadsheet tables into HTML is a point of frustration for some website owners. So, it is possible Coffee Cup should be doubly aware of this and maybe work out a way for coffeecup software itself to allow for pasting of spreadsheet data as a table into an html page, if it would be possible to do that. I think there is a paste-lines-as-table feature. I'm not sure if this could lead into paste-as-table feature?
BillR wrote:
Larry,
You don't need to request a separate email. I think you are automatically subscribed to any topic that you start. If not, look at the bottom of the messages, and you will find a button to subscribe to this topic.
Open your excel file. Click on the "Office Button" (top left). Place your cursor of the "Save As" icon and in the window that opens, select "Other Formats" at the bottom of the list. You should now have a standard "Save As" window open. At the bottom of the file listing, just below the file name box, you should see a box labeled "Save as type" and one of the options is "Web Page" which should be what you want.
You will get a warning window letting you know that you will loose several of the MS Excel features, but that is to be expected when you are saving to a web page.
I did this with a file named "budget" and a budget.htm file was created as well as a budget_files folder that contains the sheet1.htm through sheet#.htm files.
Understand that MS Office programs do not produce valid HTML code, and the files are bloated, but you will have a page that looks like an excel sheet including the tabs at the bottom.
Hope this is what you need.
Larry,
You don't need to request a separate email. I think you are automatically subscribed to any topic that you start. If not, look at the bottom of the messages, and you will find a button to subscribe to this topic.
Open your excel file. Click on the "Office Button" (top left). Place your cursor of the "Save As" icon and in the window that opens, select "Other Formats" at the bottom of the list. You should now have a standard "Save As" window open. At the bottom of the file listing, just below the file name box, you should see a box labeled "Save as type" and one of the options is "Web Page" which should be what you want.
You will get a warning window letting you know that you will loose several of the MS Excel features, but that is to be expected when you are saving to a web page.
I did this with a file named "budget" and a budget.htm file was created as well as a budget_files folder that contains the sheet1.htm through sheet#.htm files.
Understand that MS Office programs do not produce valid HTML code, and the files are bloated, but you will have a page that looks like an excel sheet including the tabs at the bottom.
Hope this is what you need.
Josh L
Registered User
4 posts
As I read through this thread, this suggestion also seems good. I guess it was years ago that I sort of gave up on making it easier for myself to go from spreadsheet to html, but now it seems obvious. It can be done (in a bloated way) with excel and it can apparently be done in a less bloated way, from what you say, with OpenOffice.
I guess I'll try to get experience with this when I get a chance.
I guess I'll try to get experience with this when I get a chance.
Adam R. wrote:
I thought it was a bit frustrating how many files Excel now uses to generate a web version of the spreadsheets. I had been playing with OpenOffice recently, which is an open source (free) alternative to Office. While I wouldn't recommend replacing MS Office if you already have it, it makes a much simpler/cleaner conversion of the Excel spreadsheets into .html files.
Larry, if you'd rather not go through the hassle of installing a suite for that sole purpose, I could try converting the file for you if you're comfortable in sharing the .xls. Just let me know.
I thought it was a bit frustrating how many files Excel now uses to generate a web version of the spreadsheets. I had been playing with OpenOffice recently, which is an open source (free) alternative to Office. While I wouldn't recommend replacing MS Office if you already have it, it makes a much simpler/cleaner conversion of the Excel spreadsheets into .html files.
Larry, if you'd rather not go through the hassle of installing a suite for that sole purpose, I could try converting the file for you if you're comfortable in sharing the .xls. Just let me know.
Adam R.
Ambassador
3,120 posts
Joshua Landess wrote:
It can be done (in a bloated way) with excel and it can apparently be done in a less bloated way, from what you say, with OpenOffice.
It can be done (in a bloated way) with excel and it can apparently be done in a less bloated way, from what you say, with OpenOffice.
I think that sums it up rather well.
Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.
