Location:
Search - xls t
Search list
Description: 利用流快速导出生成EXCEL,5万笔资料只需6秒时间左右-derived using the rapid generation of Excel, 50,000 T information only about 6 seconds
Platform: |
Size: 3599 |
Author: ha1234 |
Hits:
Description: 利用流快速导出生成EXCEL,5万笔资料只需6秒时间左右-derived using the rapid generation of Excel, 50,000 T information only about 6 seconds
Platform: |
Size: 3072 |
Author: ha1234 |
Hits:
Description: 成批修改文件名，xls转txt，合并文件的小工具-Bulk edit the file name, xls to txt, the merger document Gadgets
Platform: |
Size: 19456 |
Author: 张善 |
Hits:
Description: matlab打开txt文件和excel文件，读取其中的数据-matlab open the txt files and excel files, read the data
Platform: |
Size: 8192 |
Author: ZLJ |
Hits:
Description: PB操作EXcle的介绍
如何用PB程序在excel画表格边框线，如何改变文字大小
1．创建Excel对象
eole=CREATEOBJECT(′Excel.application′)
2．添加新工作簿
eole.Workbooks.add
3．设置第3个工作表为激活工作表
eole.Worksheets(″sheet3″).Activate
4．打开指定工作簿
eole.Workbooks.Open(″c:\temp\ll.xls″)
5．显示Excel窗口
eole.visible=.t.
6．更改Excel标题栏
-PB program drawing table border lines in excel, how to change the text size. Create Excel the object eole = CREATEOBJECT ( Excel.Application ). Add a new workbook eole.Workbooks.add 3. Set 3 worksheet the active worksheet eole.Worksheets (sheet3 " ). The Activate 4. Open specified book eole.Workbooks.Open, (" c: \ temp \ ll.xls" ). Show Excel window eole.visible = t. 6. Change the Excel title bar
Platform: |
Size: 2048 |
Author: 游龙 |
Hits:
Description: 时间序列copula工具箱，包含密度函数，分布函数，对数似然函数等等，主要正对二元copula-This zip file contains a collection of Matlab functions for research on copulas for financial time series. Some simple example code is given in copula_example_code.m . A table of contents is given in contents.xls . Briefly, the toolbox contains CDFs, PDFs, log-likelihoods and random number generators for many common bivariate copulas, including the Clayton, Gumbel, Normal, Student s t, Frank, Plackett and symmetrised Joe-Clayton (SJC) copulas. Basic code for time-varying Normal, Gumbel and SJC copulas is included.
Platform: |
Size: 1191936 |
Author: 吴云 |
Hits:
Description: XLSReadWriteII 4.0
4.00.12
! Files Excel 2007 saved in Excel 97 format could result in error message when opened in Excel ( Some formats where deleted... ).
4.00.11
! Fixes a bug introduced in 4.00.10 that casued an exception when reading some files.
4.00.10
+ Multiple print areas can now be defined. In order to define more than one area, separate the areas with the
ListSeparator character.
Example:
with XLS.InternalNames.Add do begin
BuiltInName := bnPrintArea
Definition := Sheet1!$A$1:$D$10 + ListSeparator + Sheet1!$A$12:$D$20
end
! Some files with metafile pictures where not correct written.
! Combo boxes didn t work.-XLSReadWriteII 4.0
4.00.12
! Files Excel 2007 saved in Excel 97 format could result in error message when opened in Excel ( Some formats where deleted... ).
4.00.11
! Fixes a bug introduced in 4.00.10 that casued an exception when reading some files.
4.00.10
+ Multiple print areas can now be defined. In order to define more than one area, separate the areas with the
ListSeparator character.
Example:
with XLS.InternalNames.Add do begin
BuiltInName := bnPrintArea
Definition := Sheet1!$A$1:$D$10 + ListSeparator + Sheet1!$A$12:$D$20
end
! Some files with metafile pictures where not correct written.
! Combo boxes didn t work.
Platform: |
Size: 5780480 |
Author: cheolga |
Hits:
Description: xceltk用例
-----------
- 整个表格
exceltk.exe -t md -xls xxx.xls
exceltk.exe -t md -xls xxx.xlsx
- 指定sheet
exceltk.exe -t md -xls xx.xls -sheet sheetname
exceltk.exe -t md -xls xx.xlsx -sheet sheetname
exceltk特性
-----------
- 转换Excel表格到MarkDown表格
- 支持Excel单元格带超链接
- 如果Excel里有合并的跨行单元格，在转换后的MarkDown里是分开的单元格，这是因为MarkDown本身不支持跨行单元格
- 如果Excel表格右侧有大量的空列，则会被自动裁剪，算法是根据前100行来检测并计算(Xceltk use case
At
- the entire form
Exceltk.exe, -t, MD, -xls, xxx.xls
Exceltk.exe, -t, MD, -xls, xxx.xlsx
- specify sheet
Exceltk.exe, -t, MD, -xls, xx.xls, -sheet, sheetname
Exceltk.exe, -t, MD, -xls, xx.xlsx, -sheet, sheetname
Exceltk characteristics
At
- convert the Excel table to the MarkDown table
- support Excel cells with hyperlinks
If there are merged rows of cells in Excel, separate cells are in the converted MarkDown, because MarkDown itself does not support rows of cells
If you have a large number of empty columns on the right side of the Excel table, it will be automatically cropped. The algorithm is checked and calculated based on the first 100 lines)
Platform: |
Size: 110592 |
Author: BlinKer
|
Hits:
Description: 管理员名admin（不要改），密码123456
其它通过身份证登入(如 321002194906133018)，初始密码123456(Wage management system
It is divided into two pieces of personal salary inquiry and salary management
The function of personal salary inquiry
1 check out the payroll
2 print payroll
3 modify the password
The function of wage management
1 check the payroll by time
2 added users are divided into two blocks
A single addition
Direct import of B in Database/namedaosfz.xls
3 add wage data
A addition to a single add
B is imported from Database/gzxq.xls, Database/qit.xls; payroll single (gzxq.xls) and other cost details (qit.xls)
Note: administrator name admin (don't change), password 123456
Other identity card entry (such as 321002194906133018), initial password 123456
This system is free version.)
Platform: |
Size: 376832 |
Author: 蓝色雨痕 |
Hits:
Description: 我想到过使用文件后缀名来判断类型，但是如果有人将xlsx的后缀改为xls时，如果使用xlsx的函数来读取，结果是报错；虽然后缀名对了，但是文件内容编码等都不对。
最后，推荐使用poi-ooxml中的WorkbookFactory.create(inputStream)来创建Workbook，因为HSSFWorkbook和XSSFWorkbook都实现了Workbook接口。代码如下：(dsfas assdfdf asdfasdfasdf asefqw etrq w4crt2ertcv36c 54t35tv 54yb34ty 45yb3y5 45y3vb5yt rthy t hr yty4 4 536)
Platform: |
Size: 188416 |
Author: 大大III |
Hits:
Description: 分为个人工资查询和工资管理两块
个人工资查询的功能
注: 管理员名admin（不要改），密码123456
其它通过身份证登入(如 321002194906133018)，初始密码123456(It is divided into two pieces of personal salary inquiry and salary management
The function of personal salary inquiry
1 check out the payroll
2 print payroll
3 modify the password
The function of wage management
1 check the payroll by time
2 added users are divided into two blocks
3 add wage data
Note: administrator name admin (don't change), password 123456
Other identity card entry (such as 321002194906133018), initial password 123456
A addition to a single add
B is imported from Database/gzxq.xls, Database/qit.xls; payroll single (gzxq.xls) and other cost details (qit.xls)
Note: administrator name admin (don't change), password 123456
Other identity card entry (such as 321002194906133018), initial password 123456)
Platform: |
Size: 378880 |
Author: 露露撒 |
Hits: