xlsgen 3.5 build #58 : Automatic range name creation Build 3.5.0.58 of xlsgen adds the ability to create named ranges from table headers and rows automatically. Let's consider the following data range :   A B C D E 1           2           3   TurnOver Apples Pears Bananas 4   Europe 1000 800 1200 5   Asia 1200 400 750 6   America 1700 1200 1900 By doing NewRange("B3:E6").CreateNames(true, true, false, false), xlsgen automatically creates the following named ranges based on the data range headers and columns : Apples = C4:C6 Pears = D4:D6 Bananas = E4:E6 Europe = C4:E4 Asia = C5:E5 America = C6:E6 TurnOver = C4:E6

<-- previous page

< May >
01	02	03	04	05
06	07	08	09	10
11	12	13	14	15
16	17	18	19	20
21	22	23	24	25
26	27	28	29	30
31

This site
Home
Articles

DevTools
CPU-Z
EditPlus
ExplorerXP
Kill.exe
OllyDbg
DependencyWalker
Process Explorer
autoruns.exe
Araxis
COM Trace injection
CodeStats
NetBrute
FileMon/Regmon
BoundsChecker
AQTime profiler
Source monitor
GDI leaks tracking
Rootkit revealer
Rootkit removal
RunAsLimitedUser(1)
RunAsLimitedUser(2)

Liens
Le Plan B
Un jour à Paris
Meneame
Rezo.net (aggr)
Reseau voltaire
Cuba solidarity project
Le grand soir
L'autre journal
Le courrier suisse
L'Orient, le jour
Agoravox (aggr)