-
N-sheets
以G列分成多个工作表(以宏运行VBA)
(Sub aa()
Dim a As Integer, b As Integer, c As Integer, sh As Worksheet
For a = 2 To [g65536].End(3).Row
If Cells(a, 7) <> Cells(a- 1, 7) Then
b = a
End If
c = Range("g:g").Find(Cells(a, 7), , , , , xlPrevious).Row
Set sh = Sheets.Add(, Sheets(Sheets.Count))
sh.Name = Sheets("sheet1").Cells(a, 7).Value
With Sheets("Sheet1")
Sheets("Sheet1").Range(.Cells(b, 1), .Cells(c, 10)).Copy Destination:=sh.[a2]
Sheets("Sheet1").Range("a1:j1").Copy Destination:=sh.[a1]
a = c
End With
Sheets("Sheet1").Select
Next
End Sub
)
- 2013-05-03 08:50:54下载
- 积分:1
-
DATA_EMG_test_170310
肌电信号数据,手掌做不同动作时的肌电信号,分别为伸手握拳等信号的肌电信号(EMG DATA)
- 2017-05-18 15:04:51下载
- 积分:1
-
ADOACCESS
这是一款用MFC ADO编写的数据库软件,它可以实现对ACCESS数据库的打开,添加,修改,保存,排序得一系列的功能。它利用ListCtl进行显示(This is a MFC ADO with the preparation of the database software, it can be open to the ACCESS database, add, modify, save, sort a series of functions. It uses ListCtl display)
- 2009-04-20 21:15:47下载
- 积分:1
-
apriori
关联规则挖掘算法
Apriori算法的Matlab实现 可以自动生成关联规则,计算支持度、置信度(Association Rules Mining Algorithm Apriori algorithm can automatically generate Matlab realization of association rules, computing support, confidence)
- 2020-11-29 22:19:29下载
- 积分:1
-
VS2008和Access的数据库连接及操作完整示例
连接access数据库实例,简单的操作access数据库(Connecting access database instance)
- 2018-08-13 10:14:55下载
- 积分:1
-
CeTool
一个可以打开 SqlCe 数据库文件, 输入 SQL 进行查询的小工具.(SqlCe client tool.)
- 2010-02-26 09:33:23下载
- 积分:1
-
PowerBuilder9.0进阶开发篇(实例与技巧篇)源码
说明: PowerBuilder的一些实例,适合初学者学习使用(Learning source code)
- 2020-06-16 04:00:02下载
- 积分:1
-
iif
Handling null fields in SQL queries
- 2013-09-01 04:27:04下载
- 积分:1
-
CTLib_D7
delpih使用sybase提供的ct library访问sybase数据库(delpih use of the library visit sybase ct database)
- 2006-06-17 19:48:13下载
- 积分:1
-
redis读写缓存数据
通过引用redis基础类库,实现对redis的读取和写入操作。例子比较初级。(By referring to the redis base class library, we can read and write redis. The example is more elementary.)
- 2020-06-19 17:00:01下载
- 积分:1