ColdFusion导出到Excel [英] ColdFusion export to Excel

问题描述

在将数据从数据库导出到Excel电子表格时，我很难获取正确显示的帐号。请参阅附上的图片。

I'm have a hard time getting the account number to display correctly when exporting data from database to an Excel spreadsheet. Please see the attached image.

在公司名称列下，公司名称和AMCE帐号正确显示。 Baba Gump和其他名称无法正确显示。用户必须在单元格中加倍以查看整个帐号。我有谷歌这个问题，没有一个解决方案，我试过工作。

Under Company Name column "Company Name" and "AMCE" account number are showing up correctly. "Baba Gump" and "Another Name" is not display correctly. Users would have to double in the cell to see the whole account number. I have Googled this issue and none of the solutions that I've tried worked.

推荐答案

您可以在帐号前面插入撇号。这将强制excel将数字（任何）数据视为文本。

You can insert an apostrophe ' preceding the account number. This will force excel to treat numeric (any) data as text.

这篇关于ColdFusion导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！