cesemj
asked on
How to build a Pivot Table in Visual Studio 2005
Hello,
I am using Visual Studio 2005 and I would like to build a Pivot Table on a web form. I have a existing excel spreadsheet with drop down boxes that is setup similar to a pivot table.
Question: Is there a way to create a Pivot table form using visual studio or do I have to use Access 2007 and or Sharepoint Designer?
Thank you in advance,
I am using Visual Studio 2005 and I would like to build a Pivot Table on a web form. I have a existing excel spreadsheet with drop down boxes that is setup similar to a pivot table.
Question: Is there a way to create a Pivot table form using visual studio or do I have to use Access 2007 and or Sharepoint Designer?
Thank you in advance,
Do you have the Office Web Component available?
This is a very good article that gives use step by step directions and the download link for Office Web Components.
http://www.codeproject.com/aspnet/owc11article.asp
http://www.codeproject.com/aspnet/owc11article.asp
Thank you - however we are trying to open an xls file which already exists - is this possible?
Peter,
I'm not sure I am understanding what you are trying to do with the existing xls file.
1. Are you wishing to use that as your datasource?
2. Or, are you wishing to embed a spreadsheet type viewer into your web page that will open the actual xls file?
Regards,
Keith
I'm not sure I am understanding what you are trying to do with the existing xls file.
1. Are you wishing to use that as your datasource?
2. Or, are you wishing to embed a spreadsheet type viewer into your web page that will open the actual xls file?
Regards,
Keith
ASKER
Thank you,
Sorry, I did not respond earlier, but I was at Barns & Noble reading books on asp.net 2.0 and Visual studio 2005 hoping that I can find information about a building pivot tables in VS 2005. My quest did not turn out that well, but I will not give up.
I have OWC and have developed pivot tables using access 2003 for use over the web, but I was curious if I can do the same with Visual Studio 2005. I am trying not to use OWC, because when I deploy the owc pivot table over the web, I have to make sure that each client has owc running on their host in order to view the page and also make sure that each client web settings are configured properly.
Moreover, I notice that Visual Studio 2005 has a datagrid control that is similar to an excel spread sheet, but I am not sure if the row headings can be converted to drop down boxes that will let you filter/sort. If you know a way please let me know.
Thank you,
Sorry, I did not respond earlier, but I was at Barns & Noble reading books on asp.net 2.0 and Visual studio 2005 hoping that I can find information about a building pivot tables in VS 2005. My quest did not turn out that well, but I will not give up.
I have OWC and have developed pivot tables using access 2003 for use over the web, but I was curious if I can do the same with Visual Studio 2005. I am trying not to use OWC, because when I deploy the owc pivot table over the web, I have to make sure that each client has owc running on their host in order to view the page and also make sure that each client web settings are configured properly.
Moreover, I notice that Visual Studio 2005 has a datagrid control that is similar to an excel spread sheet, but I am not sure if the row headings can be converted to drop down boxes that will let you filter/sort. If you know a way please let me know.
Thank you,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you all,