How to set width as 100%? about excel4node HOT 5 OPEN

I was asked by one of the people who use the spreadsheets that are created by the library if I could update it to do just this.
It certainly is possible, but the solution I could think of is not great and basically involves using system tools to render the font string in order to account for font size, face and decoration and measuring that. I don't like this solution because it relies on the system which is different for different developers. I haven't found a good server-side solution in pure javascript since every solution I have found relies on the browser's DOM.
If I could find an efficient way of measuring the width of a font string in pure javascript, I would then need to find an efficient way of finding the longest string. I'm thinking it would involve separating the strings of a column into different array of different styles, finding the longest string in each array, calculating the width of each longest string and then using the longest width for the column width. This would happen during the xl.write() process. I think this would be efficient enough to not cause a significant increase in the time taken to generate the excel file that would outweigh the benefit given.
I'm going to mark this as an enhancement request. If you know of or can think of an efficient way to measure the width of a string once it has been rendered, then please let me know.

from excel4node.

Thanks @natergj for the great response. I agree with your second approach that we could find the longest string that a user has put in each column and also a style applied to the column during the xl.write() process. This could make us roughly know that how much width in each column we should set for the user.

When I have time, I will try to implement this approach and see if it works.

from excel4node.

just an FYI. tomorrow night I'm planning on merging my dev branch into master. It is a complete refactor which takes care of quite a few inefficiencies and cleans up some mess of some hastily written code of the current master. you'll want to update your fork.

from excel4node.

Any updates on this?
Have you guys worked on this

from excel4node.

has anyone managed to adjust the width of the cells yet?

from excel4node.