Desktop version

Main > Forum > 1C:Enterprise Platform > 1C:Integration > Export Report from 1C as Microsoft Office Excel

Forum

Search UsersRules
Export Report from 1C as Microsoft Office Excel
#1
Active user
Points:: 3
Joined:: Sep 16, 2011

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?

Profile
#2
Active user
Points:: 32
Joined:: Sep 16, 2011

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

Profile
#3
Active user
Points:: 3
Joined:: Sep 16, 2011

Thank you Samuel! That worked!

Profile
#4
Just came
Points:: 0
Joined:: Dec 3, 2013

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.

Profile
#5
Active user
Points:: 0
Joined:: Sep 26, 2012

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

Profile
#6
Guest
Points::
Joined::

Hi,

you can use Save as button, see the screenshot:

Profile
#7
Just came
Points:: 0
Joined:: Dec 3, 2013

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

Profile
#8
Guest
Points::
Joined::

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.

Profile
#9
Just came
Points:: 0
Joined:: Dec 3, 2013

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?

Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.