Communicating with Excel Workbooks RRS feed

  • Question

  • User-215640334 posted

         I am trying to create an application that will allow user to input standardized information (facts used to drive pricing data) and then send this data to multiple "pricing" worksheets (different file for each supplier with complex calculations in each workbook - standard input/ ouput fields). After each set of data is pushed into each of the vendor pricing workbooks - the price is calculated in the workbook and the data is retrieved by the webapp. the user basicall gets a multi-vendor quote after inputting cost factors one time.   Is there a direct way to exchange data (send data to specific cells - calculate and retieve output from specific cellc) with many Excel workbooks using ASP.NET tools so I do no thave to open/close each individual workbook over the network?  




    Tuesday, May 12, 2009 5:38 PM

All replies

  • User1423673912 posted

     You can use XML transformation to generate Excel sheet. There is one good article which cover this in detail - http://www.codeproject.com/KB/office/Excel_Export.aspx?fid=329437&df=90&mpp=25&noise=3&sort=Position&view=Quick&fr=51&select=1763850. Please see another post which shows you steps - http://social.msdn.microsoft.com/Forums/en-US/xmlandnetfx/thread/10e294e5-7d90-45ea-8236-a202a3eb8e72. .

    Wednesday, May 13, 2009 12:21 AM