How can I get all the values in a particular column

[caio687]

Hello everyone!

How can I get all the values in a particular column and put a list?

Code: Select all

               Workbook content = new Workbook();
                        content.LoadFromFile("Contratação.xls");
                        Worksheet contentSheet = content.Worksheets[0];
                        List<string> numeropropostaExcel = new List<string>();
                       
                        for (int i = 1; i < contentSheet.SelectionCount; i++)
                        {
                         
                            numeropropostaExcel.Add(contentSheet.Range[i, 1].Text.ToString());
                        }

[nancy.yang]

Hi,
Thank you for your inquiry.
Please refer to the the following code to achieve your demand. If there is any question, please feel free to write back.

Code: Select all

Workbook content = new Workbook();
content.LoadFromFile("simple.xls");
Worksheet contentSheet = content.Worksheets[0];
List<string> numeropropostaExcel = new List<string>();
// Traverse all the data of the first column
for (int i = 1; i <=contentSheet.LastRow; i++)
{
   numeropropostaExcel.Add(contentSheet.Range[i,1].Value);
 }


Sincerely,
Nancy
E-iceblue support team

[nancy.yang]

Hi,

Did my code help you? Could you please give us some feedback at your convenience? Thanks in advance.

Sincerely,
Nancy
E-iceblue support team