How to extract special data from excel sheet

Help Studio
, ,
1

I wanna get data table from excel sheet, i already tried to use [for each row] activity and [if] activity , but i can’t get data what i want(as you can see in the image below, the data is in the red frame). In the excel sheet, it’s not only two tables, but it’s also have the other data. Can you help me, please…

test

2

Hi,

Usually, we can get these data using ReadRange activity. Do you mean it failed to read or read it as empty data? Can you elaborate?

Regards,

3

Because the range is not fixed, so i can’t use ReadRange. I wanna get only data is in the red frame, when i used For each row, it failed to read. If the row contain [売上高,営業利益,経常利益,当期純利益], i want to get 6 lines below. Can you help me!

4

Hi,

Can you try the following steps?

First, read all data using ReadRange activity which indicate top-left address of the table.

Then ,get row index which has “決算期（月数）” using ForEachRow or LINQ etc.

Next, re-read these data with specific range using the above row index
OR
Filter out rows which index is grater than the above row index using LINQ.

Finally we will be able to get red area data as datatable.

Regards,

5

Firstly, i read all data from excel sheet (ReadRange)⇒ read line by line (for each row) ⇒check condition if row contain "決算期（月数）"⇒ write row.item(count) in the other excel sheet.
when i did like that, the value i got is(売上高,営業利益,経常利益,当期純利益)

6

Hi,

If possible, can you share your workbook? it’s no problem if dummy data.

Regards,

7

It like below, can you take a look and show me how to do it!
Test.zip (16.6 KB)

8

Hi,

I just wrote simple sample as the following.(See Sequence.xaml)
For now, can you try this?

Testv2.zip (18.6 KB)

Regards,

9

Thanks a lots, i will refer it.
Regards,