代码之家 › 专栏 › 技术社区 › masfenix

在Excel中创建表

excel

0

masfenix · 技术社区 · 16 年前

我在为我公司的项目工作。要求是在最后创建一个Excel报告。

我目前的编码/思考方式。

Remote Server ---> Local Access table --> give user a UI to filter data however they want --> Export to excel.

However, one of my analysts asked me if we can stay away from access and use Excel only. So I was wondering, is there a way to create a "table" like access table in Excel? This way, when I import data from remote server, I can put it in a table (IN EXCEL), create a form for UI, and have everything contained in one file. I can't paste the raw data into a sheet because of performance issues (however, I have not tried it. I just assume that it is a lot faster to query a 'real' table then to search through excel cells).

你能想出另一个解决办法吗?

1 回复 | 直到 9 年前

1

Ben Hoffstein 16 年前

One option is to use Microsoft Query to directly access the remote database. In this case, the users would need to use the UI of MS Query (which isn't the prettiest) for filtering, but it would get the job done without needing the intermediate database.

这里是一个 good reference from the Microsoft site .