Re: Export to excel

ashoke — Tue, 22 Mar 2011 15:33:10 GMT

Hi There, Hope you've already done it by this time. Here is my solution to export to Excel by clicking a button for one of my query forms. If you have query, please let me know. Thanka, Ash

XPathNavigator DOM = DataSources["qYear"].CreateNavigator();

string qyear = DOM.CreateNavigator().SelectSingleNode("/dfs:myFields/dfs:dataFields/d:qYear/@qYear", this.NamespaceManager).Value;

string period = this.MainDataSource.CreateNavigator().SelectSingleNode("/dfs:myFields/dfs:queryFields/q:top/@Period", this.NamespaceManager).Value;

string filename = qyear + "_" + period;

this.CurrentView.Export(@"G:\...\Trends_totaltrans_" + filename + ".xls", ExportFormat.Mht);

Export to excel

alexia_net — Fri, 23 Jul 2010 08:13:01 GMT

Hi. I would like to know how would it be possible to export to excel the information from SQL database using InfoPath customized code. To be more accurate: I extract some information from the database on the form in a repeating table for example and the information I see on the form I want to export it to excel. I am also interested in any form of reports I can create in InfoPath, so any suggestion is welcome. Thank you!

Code

Re: Export to excel

Export to excel