Axolot Data

ykarapinar

Hello
How can I set the height and width of the comment window?

XLS[0].Comments.Add(1, 4, '', 'Hello world');

ykarapinar

Hello,

This matter is urgent to us waiting for your response as soon as possible thank you.

ykarapinar

Hello
How can I change the font name of the comment?

XLSReadWriteII6[0].Comments.Add(1, 1, '', 'text')

ykarapinar

Hello In an existing Excel file, it draw the frame borders white color. XLSReadWriteII51.FileName:='C:\XLSRWII.xlsx'; XLSReadWriteII51.Read; XLSReadWriteII51.CmdFormat.BeginEdit(XLSReadWriteII51[1]); XLSReadWriteII51.CmdFormat.Border.Style := cbsThin; XLSReadWriteII51.CmdFormat.Border.Preset(cbspOut...

ykarapinar

Hello
The sample code you have send is not resizing the dimensions of comments window. Can you please send a working code?

ykarapinar

Code: Select all

var
  C: TXLSComment;
begin
  XLS.Filename:='C:\XLS.xlsx';
  C := XLS[0].Comments.Add(1, 1, '', 'text');
  C.Xc12Comment.Col1 := 5;
  C.Xc12Comment.Col2 := 8;
  XLS.Write;
end;

I still can't resize. Am I missing something?

ykarapinar

I couldn't find how to use it, please can you give an example of its usage?

ykarapinar

Hello

Can you send code example please

ykarapinar

Code: Select all

XLSReadWriteII51.Filename:='C:\XLSRWII.xlsx';
XLSReadWriteII51[0].Comments.Add(1, 1, '', 'text');
XLSReadWriteII51.Write;

Hello
How can I resize comments?

ykarapinar

I can't get the sheet tabcolor. It always return the same number (4026531840)

Code: Select all

  XLSReadWriteII51.FileName:='C:\XLSRWII.xlsx';
  XLSReadWriteII51.Read;
  Label1.Font.Color:=XLSReadWriteII51.Sheets[0].TabColor;

ykarapinar

XLSReadWriteII51[0].MakeHyperlink(1, 1, 'file:///C:/Temp/Folder_1', 'folder link 1'); XLSReadWriteII51[0].MakeHyperlink(1, 2, 'file:///C:/Temp/Folder_2', 'link 2'); XLSReadWriteII51[0].MakeHyperlink(1, 3, 'file:///C:/Temp/Folder_3', 'link 3'); XLSReadWriteII51[0].MakeHyperlink(1, 4, 'file:///C:/Tem...

ykarapinar

When I use the following code to send to excel, in the cell created there are borders inside cells (cross) How to remove these borders? var XLSReadWriteII51: TXLSReadWriteII5; begin XLSReadWriteII51:=TXLSReadWriteII5.Create(nil); try XLSReadWriteII51.FileName:='C:\Temp\x.xlsx'; XLSReadWriteII51.Shee...

ykarapinar

The code below should format 4 columns. It works for the first 3 columns, but leaves the fourth column unformatted. var ct: Integer; begin try XLSReadWriteII51.FileName:='C:\XLSReadWriteII.xlsx'; XLSReadWriteII51.Sheets[0].Range.ItemsRef['A1:D10'].BorderInsideVertStyle := cbsThin; XLSReadWriteII51.S...

ykarapinar

procedure TForm1.Button_ExportClick(Sender: TObject); var d1, d2: TDate; begin d1:=Now; d2:=EncodeDate(2000, 1, 1); XLSReadWriteII51.FileName:='C:\xls_date.xlsx'; XLSReadWriteII51.Sheets[0].AsDateTime[0, 1]:=d1; XLSReadWriteII51.Sheets[0].AsDateTime[0, 2]:=d2; XLSReadWriteII51.Write; end; procedure...

ykarapinar

In the sample code a row is inserted to the excel document (row number 3) When the code is executed, it deletes the contents of row number 3840 Sample Excel file can be downloaded from the link; http://www.avinal.net/xlsrw.rar XLSReadWriteII51.FileName:='C:\XLSRW.xlsx'; XLSReadWriteII51.Read; XLSRea...

Axolot Data

Search found 22 matches

height and width of the comment window

Re: Font name of the Comment

Font name of the Comment

Drawing frame borders white color

Re: Resize comments

Re: Resize comments

Re: Resize comments

Re: Resize comments

Resize comments

I can't get sheet tabcolor

After the row or column is deleted, the links become corrupt

Unwanted Border In Cell

Column formatting problem

Date value in the cell not received as string

Inserting row, deletes contents of another random row