XEROF

 

xlsgen 4.0.0.77 : Table auto-filters


Build 4.0.0.77 of xlsgen exposes table auto-filters in the object model. So beginning with this build, it's possible to either create or edit existing auto-filters in tables, and write them back in XLSX and XLSB files, thanks to the AutoFilter member exposed in the table results interface.

So here is how it works :

IXlsWorksheet worksheet = workbook.WorksheetByIndex[1];

// get the first table
IXlsTable t = worksheet.Tables.Item[1];

// edit the filter in the second column of the table
t.DataResults.AutoFilter.CustomFilter[2].CustomExpression = "> 2";

// remove the filter in the third column of the table
t.DataResults.AutoFilter.CustomFilter[3].Delete();

Posted on 02-March-2017 08:56 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

 

<-- previous page

< March >
0102030405
0607080910
1112131415
1617181920
2122232425
2627282930
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)