Axolot Data

cakmakb

Hi i use single cell code, Font not changed, font size ok. XLS[0].AsFloat[2, 3] := 125.5; XLS[0].Cell[2, 3].FillPatternForeColorRGB := $AFAFAF; XLS[0].Cell[2, 3].NumberFormat := '0.000'; XLS[0].Cell[2, 3].BorderLeftStyle := cbsThick; XLS[0].Cell[2, 3].BorderLeftColor := xcRed; XLS[0].Cell[2, 3].Bord...

cakmakb

Hi XlsReadwriteII4 use like this XLSReadWriteII4[0].Range.ItemsRef[Params[1] + ':' + Params[2]].FillPatternForeColor := xcYellow; What i can use XlsReadWriteII5 XLSReadWriteII5[0].Range.ItemsRef[Params[1] + ':' + Params[2]].FillPatternForeColor := xcYellow; //Error [DCC Error] Unt_MainForm.pas(4295)...

cakmakb

Hi

XlsReadWriteII4 use like this

Code: Select all

        XLSReadWriteII4.Sheets[Params[0]].ApplyFormat.Box(Params[1], Params[2], Params[3], Params[4], cbsThin, xcYellow, xcBlack);

What i can use XlsReadWriteII5

cakmakb

Hi

XlsReadWriteII4 version use like this
XLSReadWriteII4.Sheets[1].Autofilters[Prm].Condition1.CompOperator := afoNotEqual;
XLSReadWriteII4.Sheets[1].Autofilters[Prm].Condition1.StringValue := FilterValue;

what i can use XlsReadWriteII5

Burhan Cakmak

cakmakb

Hi

Before i use II4 version like this

Code: Select all

XLSReadWriteII4.Sheets[0].SheetProtection := [spDeleteRows];

What i can use XLSReadWriteII5 version ?

Burhan Cakmak

Axolot Data

Search found 5 matches

XlsReadWriteII5 cell FontName

XlsReadwriteII5 FillPatternForeColor use

XlsReadWriteII5 > ApplyFormat.Box

XlsReadWriteII5 autoFilters

XlsReadWriteII5 SheetProtection use