Excel sheet cell background color and file protected

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hi ,

I have write a code to create a Excel sheet where i’m printing some calculated table values. It is working fine. This file will be stored in the current system specified folder - this is also done by coding.

my questions are listed below

  1. how to save the file as write protected (as a read only file)
  2. how to give the background color for headings (coloring the cells)

If anyone knows about this, Please help me to resolve the issue.

Thanks

Maria

2

anybody worked onthis? pls help to resolve the issue. How to save and open the excel sheet in readonly mode

3

Hi,

Do you use this method to save your worksheet: sysExcelWorkbook.saveAs() ? If so, have you tried setting the fourth parameter (_readOnlyRecommended) to TRUE? I wonder if that could do the job.

Otherwise , straight after the saving your worksheet, you could call WinApi::setFileAttributes() method and set the attribute of the newly created file to read-only.

Janis.

4

Thanks Janis. I tried saveas option but again it is asking for a confirmation. I believe WinApi is fine. Now the file saved as Readonly.

I want to open the same file thro code. Is it possible. If you know, pls help

5

Winapi is your friend once again: winapi::shellExecute(“C:\YOUR_FILE.xls”)

Janis

6

yes. below is the code.

application = SysExcelApplication::construct();

workbooks = application.workbooks();

workbooks.open(filename); //give the file name which you want to open

application.visible(true);