Since the process involves the use of the clipboard, there are a couple of solutions which come to my mind:
You could create a VBA macro in Excel which would format the contents:
You would need some PADLEFT or PADRIGHT kind of function:
Function PadLeft(text As Variant, totalLength As Integer, padCharacter As String) As String
PadLeft = String(totalLength - Len(CStr(text)), padCharacter) & CStr(text)
Function PadRight(text As Variant, totalLength As Integer, padCharacter As String) As String
PadRight = CStr(text) & String(totalLength - Len(CStr(text)), padCharacter)
Then use one of these functions to pad the values to the width of the largest value and place the result in the clipboard.
Have a button in Excel which launches the macro (whose result will be formatted text exported to the clipboard).
Or find an utility which can automatically format the content of the clipboard according to a specified format string. Honestly, I have never searched for such a tool, I don't even know if that exists.
"Five fruits and vegetables a day? What a joke!
Personally, after the third watermelon, I'm full."
It is impossible only excel knows how wide the original columns were, that is why it puts the delimiters in the text to mark the columns
So if you want the original column width in excel you need to get excel to put them in a cell so it gets exported with the data and you can then use it to reformat the layout.
I know for say cell A1 width the excel formula is =CELL("width", A1) which displays as a decimal number.
What exactly that number is I have no idea but you can try searching for it or just play with a few letters and font heights and you should be able to work it out.
I know but you aren't really looking at problem. The fonts in the cells are true type proportional not old school fixed pixel fonts so unless you have display formats on them you are dead out luck they wont be fixed character widths.
So the best you can probably do is the pixel width and then divid it by some number so if the font sort of averages 10 pixels width the 100 pixel column = 100/10 = 10 characters and 150 pixel width column gives you 15 characters.
You aren't going to be able to do much better than that at at least it will be somewhat columnized
I want to understand what the LoadImage function does with a file, cuts off the header ? How does it convert data?
I find the image in the resources of the file, it does not lie in the open as a picture. I read in buffer specifically the place where image of the is.
I am trying to convert some code from Linux to Windows. So, I've met two warnings at one single line of code:
const le64(0x022B4AAC34546A39ULL), // <-- warning C4341: 'SOME_LINK' : signed value is out of range for enum constant// <-- warning C4309: 'initializing' : truncation of constant value
of course, I can disable this warning, but I want to do things right how can I get rid of this warning by a correction ? It is possible ?
modified 3-Oct-19 1:50am.
Last Visit: 31-Dec-99 19:00 Last Update: 25-Feb-21 15:51