xlscell()

Read(377) Label: excel object, enter, read,

Description:

Enter cell values to an Excel file object or read values from it.

Syntax:

xo.xlscell(a:b,s ;t)

Note:

The function enters values to Excel sheet s or read values from it. Parameter xo is an Excel file object read in the non-@r@w way.

When parameter t is present, enter string t separated by the carrige return “\r”(which means the content will be entered into the next row) or tab“\t” (which means the content will be entered into the next column), starting from cell a, and save the entered data using the xlswrite() funtion. t can be a string, a sequence of sequences, or a single value.

If t is absent, read values from cell a to cell b and return them as a string; if parameter b is absent, read the value of cell a only when the counterpart parameter is a; and read values through to the last cell having a value when the counterpart parameter is a:.

Parameters:

xo

An Excel file object read in a non-@r@w way

a

Cell a

b

Cell b

s

Page number/page name; it is the first page when omitted

t

The to-be-populated data; can be omitted

Options:

@i

Insert a row after the row containing cell a and enter the specified data; by default there won’t be insertion and the existing data will be overwritten

 

@w

Enable returning a sequence of sequences of cell values at read-in

 

@g

Parameter :b will be absent and parameter t is blob type when using this option to read in or configure an image; support jpg an pnag only

 

 

@p

Work with @w to return a sequence of sequences; each sub-sequence is made up of column values

 

@n

Remove blanck spaces on both sides of a string; read an empty string as null

Return value:

No return value or a string

Example:

 

A

 

1

=file("E2.xlsx").xlsopen()

Read the Excel file object

2

=A1.xlscell("A1":"C4",1)

Read data from cell A1 to cell C4 on sheet 1 in E2.xlsx, and return it as a string

3

=A1.xlscell("B2","s2")

Read data from cell B2 to the end on sheet s2 in E2.xlsx, and return it as a string

4

=A1.xlscell("A3","s2";"aa\rbb\tcc")

Enter string aa into cell A3 on sheet s2, enter string bb into cell A4 in the next row, and enter string cc into cell B3 in the next column

5

=A1.xlscell@i("A3",;"smile")

smile Insert a row after the one containing cell A4 on sheet 1, which becomes the 4th row, and then enter string smile in it

6

=file("emp.xls").xlsopen().xlscell@w("A1":"C3")

7

D:/picture.xls

picture.xls is as below:

8

=file(A7).xlsopen().xlscell@g("B2")

9

=file("tp.xls").xlsopen()

Open tp.xls file and return the Excel object

10

=A9.xlscell@g("G8",;A8)

Write the blob type data in A8 to G8 in tp.xls

11

=file("tp.xls").xlswrite(A9)

Save the Excel object to tp.xls

12

=A9.xlscell(,"Sheet2";"cmm2")

Rename Sheet2 in tp.xls cmm2

13

=now()

Return the current time

14

=file("wtest.xls").xlsopen().xlscell@w("A1";A13)

Write the value returned by A13 to A1 in wtest.xls

15

=file("emp.xls").xlsopen().xlscell@wp("A1":"C3")

options to return a sequence of sequences whose members are column values