![SoftTree Technologies](templates/GreenTech/images/logo.gif) |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
pfg1114
Joined: 30 Jun 2021 Posts: 30 Country: China |
|
Export Excel column name error |
|
Export Excel column name error
Test Code:
declare @t as table (Id_No int, OpUName nvarchar(64));
insert into @t(Id_No, OpUName) values(1, 'a'),(2,'b');
select * from @t;
![](https://i.postimg.cc/NyqCsbsb/6.png)
|
|
Tue May 16, 2023 10:57 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7854
|
|
|
|
This is a feature by design. We parse column names for Excel export, and convert them to human readable names. Underscores and dashes get replaced with spaces, camel case names like ShipingAddress get separated by words. There are other cases, that behavior is intended. If you have noticed, Open in Excel does some other things too, like making column headers bold, applying conditional formatting to the worksheet, etc...
If you need the original column names and plan data without any formatting, please use Save to... menu and choose CSV or XLS or some other file type. The Save function copies data to files without formatting the output for display.
|
|
Wed May 17, 2023 8:18 am |
|
![](templates/GreenTech/images/spacer.gif) |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|