How to add external value in between row Array

caulson

Dear All,

i have query the data from DB using row in array

May i know how to add external value in between Array ?

Example as below.

  oSheet.Cells[4, 3] = + "*" QueryDB.Rows[r].ItemArray[0].ToString() + "*";

Azim

0 1

What error you are getting?

Try this line

oSheet.Cells[4, 3] = "*" + QueryDB.Rows[r].ItemArray[0].ToString() + "*";

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html