Add border for xslx/csv format | ww.wp.xz.cn

Resolved martelcordons
(@martelcordons)

6 years, 11 months ago

Hello, I want to ask anyone, I want to add a border in my excel file, but only the header and footer can be added to the border. Please give me a solution,Thanks before.

code attached here :
https://pastebin.com/mnbsyKpv

Viewing 7 replies - 1 through 7 (of 7 total)

Plugin Author algol.plus
(@algolplus)

6 years, 11 months ago

hi

I think you should just replace
getStyle($title_total.':'.$totalpluskode)
with
getStyle('A6:'.$totalpluskode)

Thread Starter martelcordons
(@martelcordons)

6 years, 11 months ago

Hi,

This happen when i replaced with the code above:
https://ibb.co/RzQYrbt

I want to display is like this:
https://ibb.co/dj9dMC6

but every order that has 2 or more products will look like this:
https://ibb.co/M6G4d4B

Thanks
Plugin Author algol.plus
(@algolplus)

6 years, 11 months ago
hi

Why do you use vertical and outline? Should it be allborders?
```
 'borders' => array(
    'allborders' => array(
      'style' => PHPExcel_Style_Border::BORDER_THIN
    )
  )
```
Thread Starter martelcordons
(@martelcordons)

6 years, 11 months ago

hi,

It works, thanks. But i have a problem, there is a gap between A6:I7.
https://ibb.co/VJ00SqR

Plugin Author algol.plus
(@algolplus)

6 years, 11 months ago

use getStyle('A5:'.$totalpluskode) ?

Thread Starter martelcordons
(@martelcordons)

6 years, 11 months ago

Hi,

Works well, thank you so much
—-SOLVED——

Plugin Author algol.plus
(@algolplus)

6 years, 11 months ago

you’re welcome

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Add border for xslx/csv format’ is closed to new replies.

7 replies
2 participants
Last reply from: algol.plus
Last activity: 6 years, 11 months ago
Status: resolved