I have an excel sheet containing 2 columns .ex of first column[sil th ih s sp m ae n sp] I want to convert this first co | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

I have an excel sheet containing 2 columns .ex of first column[sil th ih s sp m ae n sp] I want to convert this first co

I have an excel sheet containing 2 columns .ex of first column[sil th ih s sp m ae n sp] I want to convert this first column to second column in this form[sil th+ih th-ih+s ih-s sp m+ae m-ae+n ae-n sp]. how I do this in c# . I tried : if (oRng.Cells[rCnt, cCnt] != null && oRng.Cells[rCnt, cCnt].Value2 != null) { if (oRng.Cells[rCnt, cCnt] = Convert.ToBoolean(Convert.ToInt32("h#"))) { oRng.Cells[rCnt, cCnt + 1] = oRng.Cells[rCnt, cCnt]; } but error:string input wasnot in correct format.

11th Mar 2017, 8:45 PM
Doaa Mohamed
Doaa Mohamed - avatar
2 Answers
0
Is this on SoloLearn, or can you put it in a SoloLearn private program to share on this thread?
21st Jun 2019, 8:23 AM
SQrL
SQrL - avatar
0
What int32 are you expecting h# to convert into? Is that supposed to be a hex number”
21st Jun 2019, 8:31 AM
SQrL
SQrL - avatar