My compliments for such a concise demonstration of the problem. I easily reproduced the behavior, but I'm not sure that the configuration you're looking for is possible in Excel. here's what I did.. through excel, I typed a value into 2 cells and merged them. Then I clicked on the wrap button, and nothing happened! I took a closer look, and the merge function not only merges, but centers the text as well. I'm guessing this means that merging and wrapping inside of excel don't work together. The exporter is properly setting both conditions, as indicated by the properties of those cells inside of Excel.
If you know of a way to get these two conditions working inside of Excel, we can certainly look at adding this as an enhancement to our exporting engine, but as it stands right now, I don't think this is possible.
-Tony
Hi,
The save method of the workbook takes the location where the excel file is to be created.
oWorkbook.save("C:\Documents and settings\abc\desktop")
Instead of hardcoding the location I want the user to select the location of where the excel is to be created. I would appreciate if some replies to my post.
Thanks,
Junaid
Alright. Given that this is now a known limitation of Excel and no fault of our own (wink wink).... I have come up with a (partial) solution that will work. I just need a little help from you guys following through. In the attached project you can see that I have added a new column. This column is the exact width of both the original column and the column it was to be merged with added together. In other words ColumnA.Width + ColumnB.Width = ColumnC.Width. ColumnC has its formatting and .Value set to exactly that of ColumnA PLUS it is set to wrap.
This provides me with a row that has the height properly set inside the resulting excel file. One problem is that if you delete ColumnC or the value of ColumnC the row will then revert back to the default height. A working solution for me (at least) would be to be able to set the print area (File->Print Area->Set Print Area in Excel) and simply not print the unneeded column. I couldn't not find this feature in your Excel Exporter under Print Options or anywhere else.
If you have any other suggestions I will be glad of the help. Thanks again.