Community
Showing results for 
Search instead for 
Do you mean 
Reply

programatically export to excel pivot table

New Member
Posts: 1
Country: USA

programatically export to excel pivot table

Greetings,
I am trying to export a contact list to an excel pivot table via C#.Net. When I invoke the following code, I receive a fairly generic exception error.
 
Code Snip:

cListAll = application.ActFramework.Contacts.GetContacts(null);
application.UIImportExportManager.Excel.ExportListView("myWorksheet", contactListAll);

Error:
+  $exception {"Exception from HRESULT: 0x800A03EC"} System.Exception {System.Runtime.InteropServices.COMException}
I've also tried the following:

Act.UI.ImportExport.Excel ExcelExport = new Act.UI.ImportExport.Excel();
ExcelExport.ExportListView("mySheet", cListAll);

and receive the following error when I try to compile:
Error 1 The type 'Act.UI.ImportExport.Excel' has no constructors

What am I missing??
Thanks!