Forum

Hello everyone!
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 common module to use Scheduled Jobs?
Anyone can show me some code sample, pls?

Hi Cao Bao!

Please see the sample code:

newSpreadsheetDocument = New SpreadsheetDocument;
   
// Here is the code that populates your report with data
   
   
TempFileName = GetTempFileName("xlsx");
   
newSpreadsheetDocument.Write(TempFileName, SpreadsheetDocumentFileType.XLSX);

Hi Aleksandr

Thanks so much . It's work. But I want it auto run report and save it without using any button. Do you have any way to suggest for me about it?

Dear Cao Bao,

it depends on where/how often you want to run this procedure. You can set up an automated routine (reglament) task which will run at certain periods of time. And put the above code in this procedure.

Kind regards,
Alex

Hi Alex Ogourok,
Thank you so much. I will research it

Hi Cao Bao,

If you want to do periodic report generation, then you can use the mechanism of "Scheduled jobs".

It's necessary to create a new "Scheduled job" and create the required program code (scr.1).

Then you need to set the schedule for running this job (scr.2)

Attention! The mechanism of "Scheduled jobs" works only for the client - server architecture 1C.

Aleksandr

Aleksandr Biryukov,
I did it and it's work. Thanks so much