Resolved How to change the design of the exported XLSX

The update is out, and you can export als XLSX, but how do I change certain things? LIke how large a specific field must be, or the border color? Where can i do that?

Hello,

The update is out, and you can export als XLSX, but how do I change certain things? LIke how large a specific field must be, or the border color? Where can i do that?

We only support the export to XLSX file but not the design of fields in XLSX file. So there is no option in RO CSVI to specify the design of export file.

Hello,

Hm thats weird that Roland then told me this.

There seems to be some misunderstanding. Roland did not mentioned that it is possible to style the export XLSX file in the topic here.

Is it possible to change the core code?
So that maybe in the core code of the XLSX generation I can set certain values?

We use an external library to generate XLSX file. I doubt if you can edit the code. The RO CSVI helper code is in administrator/components/com_csvi/helper/file/export/xlsx/csvimproved.com. There is no code for designing in CSVI helper but that is the place where the library methods are used to generate XLSX data. The library files are in folder administrator/components/com_csvi/vendor/phpoffice/phpspreadsheet. Remember that if you edit any of the core files an update to RO CSVI will overwrite the changes.

 $this->spreadSheet->setActiveSheetIndex(0)->getDefaultColumnDimension()->setWidth(12);



$this->spreadSheet->setActiveSheetIndex(0)->getColumnDimension(A)->setWidth(20);

$this->spreadSheet->setActiveSheetIndex(0)->getColumnDimension(B)->setWidth(20);

$this->spreadSheet->setActiveSheetIndex(0)->getColumnDimension(C)->setWidth(20);

$this->spreadSheet->setActiveSheetIndex(0)->getColumnDimension(D)->setWidth(4);

$this->spreadSheet->setActiveSheetIndex(0)->getColumnDimension(E)->setWidth(4);

$this->spreadSheet->setActiveSheetIndex(0)->getColumnDimension(F)->setWidth(20);

$this->spreadSheet->setActiveSheetIndex(0)->getColumnDimension(G)->setWidth(8);





$this->spreadSheet->setActiveSheetIndex(0)->freezePane('B1'); 

I have some questions about the export. I have added column widths, borders, all kinds of stuff, so I am very glad with that.

But is there some sort of function to get the contents from the export? For example, I want to add a border to a row or rows where the ID of the exported row is the same. But I'm nto sure how to do that.

But is there a way to do this programmatically? For example loop through all the header rows and then set the width based on the name of the column?

for($i = 0; $i <= 26; $i++)

{

	$numeric = $i % 26;

	$letter  = chr(65 + $numeric);

	$this->spreadSheet->setActiveSheetIndex(0)->getColumnDimension($letter)->setWidth(20);

}