データテーブルの分割について

[ukio (TakayukiDf)]

Excelのシートを空白行で分けて、データテーブル型に格納したいと思っています。
何か方法はありますでしょうか？
※イメージとしては、Excel１~３行に一つのデータ。空白行挟んで次のデータと続いています

[Gokul001 (Gokul Balaji)]

Hi @ukio

Welcome back to community

Try this below expression

DT.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable

Have look on the thread

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

How to check if a row in a DataTable is made up of all empty cells?

I have an Excel sheet with lots of data, and it has 6 different sections or blocks, all separated by a row with no data. For example, there is a table from row 1 through row 10, and this is block 1. Then there is an empty row on row 11, and block 2 starts on row 12, and so on. Even though there is only one sheet, it has 6 blocks, and I have to process them separately. So I want to use the empty row as a delimeter. How should I do this? Right now, I am using the following logic, but this is ki…

How to check value in cell is empty

i need to compare two excel sheets ,where one column (certain cell )which doesnt contains any values (empty cell) i need to check whether the cell is empty,if cell is empty then i have to put yes otherwise no any help regarding this?

Regards
Gokul