FP 2002 import spreadsheet

R

ron

i am new to FP but have a small web site up. Now i would like to add
our local cemetary records which are in an excel spreadsheet. About
1000 rows by 10 columns. What is the easiest way to import this data
into FP and also show grid lines for readability on page?

Any help would be appreciated.

Ron
 
S

Stefan B Rusynko

Or In Excel, select all cells - Edit Copy
Then in an FP page Edit Paste




| You can save the spread sheet as a web page from within excel.
|
|
| | > i am new to FP but have a small web site up. Now i would like to add
| > our local cemetary records which are in an excel spreadsheet. About
| > 1000 rows by 10 columns. What is the easiest way to import this data
| > into FP and also show grid lines for readability on page?
| >
| > Any help would be appreciated.
| >
| > Ron
| >
|
|
 
R

ron

Thanks for the response. Tried both ways.
Also tried using the spreadsheet component, then paste data into that.
Are any negatives in using the spreadsheet component feature vs. setting
up several pages made from parts of the spreadsheet? Would like to freeze
headings so users wouldn't have to be spreadsheet literate to use page.
Is that possible using the component or can that be carried in by doing it
spreadsheet before it is pasted in?

Thanks again

Ron
 
S

Stefan B Rusynko

Depending on your audience (and whether they all have Excel or the OWC) Save as Web Page (Interactive) or just as .xls Spreadsheet



| Thanks for the response. Tried both ways.
| Also tried using the spreadsheet component, then paste data into that.
| Are any negatives in using the spreadsheet component feature vs. setting
| up several pages made from parts of the spreadsheet? Would like to freeze
| headings so users wouldn't have to be spreadsheet literate to use page.
| Is that possible using the component or can that be carried in by doing it
| spreadsheet before it is pasted in?
|
| Thanks again
|
| Ron
|
|
| Stefan B Rusynko wrote:
|
| > Or In Excel, select all cells - Edit Copy
| > Then in an FP page Edit Paste
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| > | You can save the spread sheet as a web page from within excel.
| > |
| > |
| > | | > | > i am new to FP but have a small web site up. Now i would like to add
| > | > our local cemetary records which are in an excel spreadsheet. About
| > | > 1000 rows by 10 columns. What is the easiest way to import this data
| > | > into FP and also show grid lines for readability on page?
| > | >
| > | > Any help would be appreciated.
| > | >
| > | > Ron
| > | >
| > |
| > |
|
 

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

Top