How to update an open Excel in C# using OLEDB?

Updating website using excel?

• Hello, i am a manager of a football club and i have created the website. i would like to update the players statistics via excel and then update them on the website .. so basically all i have to do is update the spreadsheet which will then update the website. my website is longbentonfc.co.uk does anyone know what a mean and if they do could they tell me how i could do it?

• Answer:

  First of all, it would have helped to know which version and update level of MS-Excel you are using. If you wish to use MS-Excel, then just select and save the spreadsheet data you want to display. But use the FILE ==> SAVE AS WEB PAGE... option, not a normal workbook save. Be sure to click the Selection bullet when the Save As dialog window appears. (I doubt you have your own server, so the Add Interactivity option will not be required.) When you click the Publish button, you will be given further options and selections to set before creating the HTML document. It can be a simple showing of your data, then you can just include that within another web through the use of Frames, or wrap additional HTML text around the saved document. .