Split numbers in a cell

[trozzi1957]

Hi-

In a cell... I have the value set as 1,2,3,4,5. What method do I get the value to split it into an int[]?

Thanks,
-Thomas

[trozzi1957]

GetText throws a null exception.

[kylie.tian]

Hi,

Thank you for your inquiry.
Please refer to the following code to achieve your requirement. If it diesn't help, please provide your sample Excel for investigation.

Code: Select all

 
            Workbook wb = new Workbook();
            wb.LoadFromFile(fileName);
            Worksheet sheet= wb.Worksheets[0];
             //Gets the cell text
            string str = sheet.Range[1, 1].Text;
            //Split into string[]
            string[] arr = str.Split(',');
            int[] result = new int[arr.Length];
            //Convert to int[]
            for (int i=0;i<arr.Length;i++)
            {
                result[i] = Convert.ToInt32(arr[i]);
            }

Sincerely,
Kylie
E-iceblue support team

[kylie.tian]

Hi,

Hope you are doing well!
Has your problem been effectively solved now? Could you give us some feedback at your convenience?
Thanks in advance.

Sincerely,
Kylie
E-iceblue support team