搜索资源列表
AutoProject
- Automate Excel using MFC and worksheet
excelfilesplitterbasedonfieldcontents
- split the worksheet up (ex. "master.xls") into new files in multiples of 50 rows (ex. "chunk1-rows1-50.xls", chunk2-rows51-100.xls", etc.). Divide huge spreadsheet into several more manageable chunks.
Export_Excel
- Exporting Excel Worksheet
Project1
- vb 读取EXCEL中的趋势图比如D盘下有一名为graph的Excel文件。里面有一个直方图。现在新建一个窗体，窗体上放置一个PictureBox，一个按钮。单击按钮，将读取D:/graph.xls中的直方图到图片框-Private Sub Command1_Click() Dim mXlsApp As Excel.Application 应用 Dim mXlsBook As Excel.Workbook 工作薄 Dim mXlsSheet As Excel.Worksheet
OperateExcel
- 读取Excel文件，将数据保存到一个DataSet中,并显示在界面上的DataGrid中。可以读Excel2003和Excel2007两种文件格式，并自动获取工作表的名称。-This simple program can read Excel files,then save all data to a DataSet and display them in DataGrid control. It can support file format of both Excel2003 and Exc
plgm
- 可根据EXCEL表格的设置，对文件进行批量改名，分类，将文件夹下文件名写入EXCEL工作表。 -According to the EXCEL table settings, batch file rename, sort, file the folder name into EXCEL worksheet.
GetUser
- Excel 工作表读取当前用户名的算定义宏。-Excel worksheet to read the current user name count defined macros.
20111107-03
- 在Excel工作簿的工作表中循环以查找特定工作表-In the Excel worksheet in the workbook to find a specific worksheet cycle
New-Microsoft-Excel-Worksheet
- THIS A TESTING FILE WHICH INCLUDES AN AUTO GENERATED EXCEL FILE-THIS IS A TESTING FILE WHICH INCLUDES AN AUTO GENERATED EXCEL FILE
PBExcel
- PB操作EXcle的介绍 如何用PB程序在excel画表格边框线，如何改变文字大小 1．创建Excel对象 eole=CREATEOBJECT(′Excel.application′) 2．添加新工作簿 eole.Workbooks.add 3．设置第3个工作表为激活工作表 eole.Worksheets(″sheet3″).Activate 4．打开指定工作簿 eole.Workbooks.Open(
Excel
- 该演示代码示例了使用VB进行比较2个Excel工作表文件是否存在不同，程序先把工作表载入到表格文件，然后输出工作表的差异的详细报告，并以红色提示。-The demo code examples use VB to compare two Excel worksheet file, the program first worksheet loaded into a spreadsheet file, and then output a detailed report of the workshee
EXECL-CREAT
- 根据模版文件复制所需工作表，自动生成相关数据。-According to a worksheet template files needed to automatically generate the relevant data.
Excel_mulu
- Excel表格自动生成目录，需要在表格中新建名为“目录”的工作表，讲源码复制粘贴至该工作表的代码窗口中保存即可-Excel spreadsheet automatically generated directory, you need to create a new table named " directory" worksheet, copy and paste the source speaking to the worksheet' s code window c
EXCEL
- VC EXCEL接口:workbook worksheet 等一系列操作接口-excel interface IN vc
Contents-Page-create-hyperlinks
- 在目录页列出本工作簿的所有工作表并建立超级链接 使你在点击目录对应工作表的名字即可进入相应的工作表-Listed in the catalog page workbook all worksheets and establish hyperlinks So you click on the name of the directory corresponding worksheet to enter the appropriate worksheet
excel将一个工作表根据条件拆分成多个工作表.txt
- excel将一个工作表根据条件拆分成多个工作表(Excel divides a worksheet into multiple worksheets according to the criteria)
excel快速将每个工作表另存为单独的工作簿文件
- excel快速将每个工作表另存为单独的工作簿文件(Excel quickly saves each worksheet as a separate workbook file)