Export Report from 1C as Microsoft Office Excel

1C:Enterprise platform integration capabilities and techniques

#1
People who like this:0Yes/0No
Active user
Rating: 6
Joined: Sep 16, 2011
Company: TLG Integration

Hello!
Is there an easier way than using Microsoft Office Excel COM object to export a report from 1C in Excel format?
I can see in menu that it is possible to save as Excel2007 sheet-... (*.xlsx). How can I do the same in my own command?

 
#2
People who like this:0Yes/0No
Active user
Rating: 3
Joined: Sep 16, 2011
Company: individual

Silvia, you can use Write command of the spreadsheet document where the result of your report is output:
SpreadsheetDocument.Write(FileName, SpreadsheetDocumentFileType.XLSX);

 
#3
People who like this:0Yes/0No
Active user
Rating: 6
Joined: Sep 16, 2011
Company: TLG Integration

Thank you Samuel! That worked!

 
#4
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Dec 3, 2013
Company: Claritus Consulting

Hello

Is there any way to export reports from User Interface?
and in which formats we can do the exports?
I also want to send the data in transformed data.

Edited: Prashant Arora - Dec 11, 2013 10:14 PM
 
#5
People who like this:0Yes/0No
Active user
Rating: 7
Joined: Sep 26, 2012
Company: individual

Yes, you can export. You need use command File\Save as. And then you can select different formats: .html, .xls, .xlsx, .pdf, .txt, .ods and some other

 
#6
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Hi,

you can use Save as button, see the screenshot:

 
#7
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Dec 3, 2013
Company: Claritus Consulting

Is this exporting feature also available in 1C Accounting suite version 7 ?

Edited: Prashant Arora - Dec 11, 2013 11:38 PM
 
#8
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

What is 1C Accounting suite 7? 1C:AccountingSuite is available for 1C:Enterprise platform 8.3 and the latest version is 1.1.33.1. If you mean 1C:Accounting for 1C:Enterprise platform 7.7, you can request for support by sending an email to hline@1c.ru in Russian only.

 
#9
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Dec 3, 2013
Company: Claritus Consulting

Thanks for the above help
I also need to know-
Is there any way through which i can export all the entries/transactions(the whole database),not specifically reports?
and the formats in which I can do?

 
Subscribe
Be the first to know tips & trick on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.