dreamweaver+courses+in - Import / Use Excel Spreadsheet in Dreamweaver | Dreamweaver forum

Resolved · Low Priority · Version Standard

Mon 9 Jul 2007, 18:51 Delegate Gustavo said...

Gustavo has attended:
No courses

Import / Use Excel Spreadsheet in Dreamweaver

I'm trying to import a file to my website so it can be use as a reference for some item I have.

There're 2 cells that need an input so it work properly, how do I import it so it can be use thru the website they way I can use it in Excel normally?

Thanks

Tue 10 Jul 2007, 10:58 Trainer Rich said...

RE: Import / Use Excel Spreadsheet in Dreamweaver

Gustavo,

You can upload excel documents as normal, and link to them so that people can download/view the document (assuming they have Excel installed).

To use/edit data from the excel document in your web page may be a bit more tricky. There may be plug-ins that allow visitors to your site to update fields, but the only one I'm aware of is the new sharepoint one.

Most people develop using a database to store values. eg. SQL, MySQL or MSSQL.

These resources may help:
http://www.badblue.com/excelweb.htm
http://blogs.msdn.com/excel/archive/2005/11/09/490926.aspx

Good luck.

Regards, Rich

Sun 15 Jul 2007, 03:01 Delegate Gustavo said...

RE: Import / Use Excel Spreadsheet in Dreamweaver

Hi Rich

I'm really a noon at this so I'm a bit lost right here. If you can ellaborate more about this it would really help.

I ahve a seconds one for you: How can I import a html website into sharepoint and use my website from sharepoint?

Regards

Gustavo

Mon 16 Jul 2007, 09:45 Trainer Rich said...

RE: Import / Use Excel Spreadsheet in Dreamweaver

Gustavo,

The short answer is: you should really use a DATABASE for your website instead of a SPREADSHEET. Databases are more flexible and easier to manage.

We have not begun sharepoint training yet, so you may need to direct your questions elsewhere. However, I imagine you would create some sort of 'site' in a similar way to Dreamweaver. This would involve pointing Sharepoint to a local folder on your computer or a network drive.

If you haven't got a local copy of your web site, you can create an empty local folder, then FTP download all the web site files to this local folder using Sharepoint or Dreamweaver, or any other FTP program such as WS_FTP or Cute FTP.

Regards, Rich

Training courses