how to import an xls sheet to HTML file?

Question

I am not a coder , but I can follow the steps, I am using WP as a Hotel Directory , now I had a patern for all pages , and all the information to fill the patern is in the excel sheet so my question is

Is there a way to import the information of the excel sheet to go inside the HTML file?

More explanation

the HTMl file is for examlpe

td CLASS="" HEIGHT="20" WIDTH="175">Property Name:
Hotel Name

This Hotel Name is in the excel sheet
How can I import this information from the excel sheet to its proper place in the HTMl file

Answer 1

Excel has a "Save as Web Page..." menu option. Just edit the HTML document it creates (or copy and paste the ... code into your existing document).

Answer 2

I like Steve's hack. Other answers would require a whole new method of thinking. XML is the buzzword. XML is data as a text file. A style sheet or computer programming presents the page to the browser. XML offers the cleanest method for editing data because it is separate from the formatting.



If you have not experience with XML, use Steve's hack to get your web pages up and running. And start researching XML technology for later.

Answer 3

It depends how posh you want it. I produce lots of pages with tables from Excel but go for minimum file size via Save As Formatted Text (Space delimited) (.PRN) and load with Notepad. Using

 tables align using Courier New font.





 



                             Opt    No opt


CPU                MHz    MFLOPS    MFLOPS





Athlon XP          2080    764.03    136.05


Pentium M          1862    834.29    181.05


Pentium 4          3066    840.27    174.64


Athlon XP          2338    859.43    153.21


Athlon 64          2150    811.86    142.80


Athlon 64          2211    838.22    145.60


Pentium 4          3678   1017.01    209.01


Core 2 Duo 1 CP    2400   1315.42    195.13


              
            

Answer 4

According to the question on importing the Excel 2007 data to SQL Server 2005, I would like to provide you the suggestions as follows: 1. Connection string issue: Please check if you are able to connect both Excel 2007 and SQL Server 2005 as the data source successfully. The excelConnection seems to be find as you provided. Then you can also add "HDR=YES" to indicate that the first row contains columnnames, not data. "HDR=No;" indicates the opposite. This can avoid the first row confused when importing to the SQL tables. 2. Please test your ODBC SQL Server connection string in order that the connection to SQL Server is correct. Except the ODBC, you can also use SqlConnection and execute the SqlCommand object with the statement that includes the excelConnection in your VB.NET code, but not just integrate the whole in one SQL statement. The following article shows you the way: Import Excel sheet into Table 3. Except the above methods, you can consider to use SqlBulkCopy class to import. The following article shows you the example: Import Excel Spreadsheet Data into SQL Server Database Table Using SqlBulkCopy 4. There is a KB article in MSDN on the topic. Although the article is not applied for SQL Server 2005, you can also learn on SQL Server Data Transformation Services (DTS), Microsoft SQL Server 2005 Integration Services (SSIS), SQL Server linked servers and SQL Server distributed queries. They are helpful on your work. How to import data from Excel to SQL Server Hope that can help you.

Answer 5

Hi Basboosa,

actually i dont know what u r talking about but i think if u take a hot shower and get enough sleep then u can solve it by ur self :)