使用Excel Automation更改电子表格标题 [英] Using Excel Automation to change spreadsheet title

问题描述

我有一个问题。我可以用它来更改Excel文件吗？我有一个按钮将我的记录导出到Excel电子表格，但它没有格式化或看起来不错。我不知道在创建之后是否可以使用它来格式化它。


[管理员注意：这个帖子已从本周的文章如何在Access中使用Excel函数]

解决方案

我有一个问题。我可以用它来更改Excel文件吗？我有一个按钮将我的记录导出到Excel电子表格，但它没有格式化或看起来不错。在我创建之后，我不知道是否可以使用它来格式化它。

Youo将使用这个概念，仅扩展，一旦导出记录就格式化Excel电子表格。请阅读我们自己的NeoPa本教程：
应用程序自动化

我想我还是要了解代码是如何工作的。现在，这是我现在的代码：

的展开 <跨度类= codeDivider > | <跨度类= codeLink 的onclick = 全选（此）; >选择 <跨度类= codeDivider > | <跨度类= codeLink 的onclick = 自动换行（在此）;>裹 <跨度类= codeDivider > | 行号

我已经从文章中拆分了这个帖子。请在此处继续对话。


ADMIN

I have a question. Can I use this to change an Excel file? I have a button that exports my records to an Excel spreadsheet, but it is not formatted or looks nice. I didn''t know if I could use this to format it after I create it.

[Admin Notes: This thread has been split from the Tips of the week article How to use Excel Functions in Access]

解决方案

I have a question. Can I use this to change an Excel file? I have a button that exports my records to an Excel spreadsheet, but it is not formatted or looks nice. I didn''t know if I could use this to format it after I create it.

Youo would use this very concept, only expanded, to Format an Excel Spreadsheet once Records have been exported. Read this Tutorial by our own NeoPa:
Application Automation

I guess I still to new to understand how the code would work. Right now this is the code I have now:

Expand|Select|Wrap|Line Numbers

I have split this thread from the article. Please continue the conversation in here.

ADMIN

这篇关于使用Excel Automation更改电子表格标题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！