Comments by kvchennai

kvchennai 8-Feb-16 5:49am View

Actually I have copied that code from two functions, that's why spelling mistake.

Just now I got to know that problem with excel limitation. Old version (xls) supports max. 65536 rows and new format (xlsx) support 1048576 rows. Now issue is, even with the new version I couldn't able to pass more than 65536 like [{0}$A65537:A65537] due to limitation but it can be possible when I use 'where' condition. But 'where' takes more time to update doc. Please help me or how to use row no. in 'where' condition instead of column name and value

kvchennai 8-Feb-16 2:07am View

like this "Update [sheetname$] set F5 = 12 where rowno. = 12400"

kvchennai 8-Feb-16 2:06am View

here
myCommand.ExecuteNonQuery();

or if I have update query to update specific cell without using header column. Let say by using row no. like A106880...

kvchennai 8-Apr-15 12:54pm View

Yeah you are right, when write function done his job then I can use export function to make the SQLite database as a MySQL database.

If you don't mind, do you have any export solution from SQLite to MySQL programmatically c#.

Comments by kvchennai (Top 4 by date)