Export Report from 1C as Microsoft Office Excel

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?

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

Thank you Samuel! That worked!

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.

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

Hi,

you can use Save as button, see the screenshot:

Attached Files

Download report.png (64.9 KB)

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

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.

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?