Browser link to a spreadsheet
-
I have a need to gather data from an Excel spreadsheet, I have no information about the sheet but I want the user to be able to link a cell in a datagrid or a text control to a cell in an excel spreadsheet. I have looked at some of the spreadsheet controls and have found no mention of remote referencing capability. I could set up the read capability if it was winforms but am I going to be limited by the lack of IO via the browser.
-
I have a need to gather data from an Excel spreadsheet, I have no information about the sheet but I want the user to be able to link a cell in a datagrid or a text control to a cell in an excel spreadsheet. I have looked at some of the spreadsheet controls and have found no mention of remote referencing capability. I could set up the read capability if it was winforms but am I going to be limited by the lack of IO via the browser.
Mycroft Holmes wrote:
but I want the user to be able to link a cell in a datagrid or a text control to a cell in an excel spreadsheet.
What do you meant by link to a cell? Do you mean linking to excel file and when it opens, focus should be on a specified cell? If yes, I believe it is not possible because of the limitations you already aware. :)
Navaneeth How to use google | Ask smart questions
-
Mycroft Holmes wrote:
but I want the user to be able to link a cell in a datagrid or a text control to a cell in an excel spreadsheet.
What do you meant by link to a cell? Do you mean linking to excel file and when it opens, focus should be on a specified cell? If yes, I believe it is not possible because of the limitations you already aware. :)
Navaneeth How to use google | Ask smart questions
Actually I want to configure a web form so when I click a button the form will go get the data in the cells from the xls and populate the form. I am currently thinking I should be able to use a DLL (this is behind the firewall) to get the data for each cell, can't think of any other way.
-
Actually I want to configure a web form so when I click a button the form will go get the data in the cells from the xls and populate the form. I am currently thinking I should be able to use a DLL (this is behind the firewall) to get the data for each cell, can't think of any other way.
-
Part of the problem is that the data structure is so crappy that OLEDB spits the dummy and won't talk to the sheet. Each branch has it's own flavour of sheet that does the same thing. The only way seems to be to link textbox to cell. These are very high level reports so there are limited cells to link.
-
Actually I want to configure a web form so when I click a button the form will go get the data in the cells from the xls and populate the form. I am currently thinking I should be able to use a DLL (this is behind the firewall) to get the data for each cell, can't think of any other way.
Mycroft Holmes wrote:
Actually I want to configure a web form so when I click a button the form will go get the data in the cells from the xls and populate the form.
This is possible if you have the excel file on server. Use Excel interop or OLE DB to read data from excel.
Navaneeth How to use google | Ask smart questions
-
Mycroft Holmes wrote:
Actually I want to configure a web form so when I click a button the form will go get the data in the cells from the xls and populate the form.
This is possible if you have the excel file on server. Use Excel interop or OLE DB to read data from excel.
Navaneeth How to use google | Ask smart questions
Excel sheet is on the client and the data does not conform to a reasonable (any) format.