This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / Help on Excel_数据库整理问题我把一个DATASET 从CRYSTAL REPORT 里DOWNLOADED 出来 AND SAVE AS .XLS FILE(EXCEL 文件格式),但发现每条数据的COLUMN的VALUE 有些在第一行, 有些在第二行, 我的数据SIZE 是有几万条记录, 我不可能一条条记录来CUT, PASTE, 谁能告诉我用EXCEL 的功能, 如何把它们快速整理成数据库形式.即是, 每一条记录, 每一个COLUMN'S VALUE 在同一行.
-shelley57(shelley);
2005-3-18
{314}
(#2187037@0)
-
与其从EXCEL里找答案,不如从你CRYSTAL REPORT 的设置查起.
-wonton_soup(Wonton Soup);
2005-3-18
(#2187090@0)
-
What's version your CR? there are two excel export formats: MS Excel and MS Excel data only.
-willington(居无定所);
2005-3-18
(#2187181@0)
-
Crystal report 显示的是数据库的格式, 但当我SAVE AS .XLS FILE 就变成错行, 问公司那个搞CRYSTAL REPORT, 他说他没有办法, 要我在EXCEL 上面操作变成数据库的格式.这是一个CROSS TABLE 变成数据库的格式
-shelley57(shelley);
2005-3-18
(#2187558@0)
-
:)+You must pay for getting this done
-kpax(kosmo);
2005-3-18
{34}
(#2187679@0)
-
Working with CR for a couple of years, I never trust its Excel output format. Some delimit file format like CSV should be better
-willington(居无定所);
2005-3-18
(#2188543@0)
-
试一试别的格式。CR有没有dBASE，或者text file的选择？
-23456789(大白呼);
2005-3-18
(#2188244@0)
-
一般来说应该能存成csv文件，excel文件可能不是flat text 文件
-oasis(oasis);
2005-3-18
(#2188626@0)
-
Could you tell me what difference between CSV and XLS?
-shelley57(shelley);
2005-3-18
(#2188783@0)
-
CSV is one of ASCII formats.
-23456789(大白呼);
2005-3-19
(#2189415@0)