search

natergj / excel4node

Node module to allow for easy Excel file creation
MIT License
1.38k stars 215 forks source link

Applying style to range given 4 cell corners of the range? #224

Closed nowherenearithaca closed 6 years ago

nowherenearithaca commented 6 years ago

I saw that styles can apparently be applied to ranges (based on a comment in 2014), but how do you do this if you have the cell coordinates of the 4 corners of the range?

thanks!

nowherenearithaca commented 6 years ago

ok - looks like you just add the two coordinates to the cell call

I am wanting to put a border around the range, NOT apply a border to each individual cell

nowherenearithaca commented 6 years ago

ok - I added borders to the cells on the corners separately, but was curious is there is an outine you can do in one statement for the range

natergj commented 6 years ago

I have an open enhancement request for this functionality in https://github.com/natergj/excel4node/issues/200. You can watch that issue for updates and hopefully I'll get to that soon. Right now, the way you did it is the required workaround.