excel problem
-
i did a project that takes datas from the texboxes and open an excel sheet and show the datas in excel. the program works in my pc properly. but when i tried it in another pc it does not work. gave me the error "Row height must be 0 - 255 characters long" what is the problem i didnt find. i load the runtimes of microsoft office to another pc. what was the error or what didnt i do?
-
i did a project that takes datas from the texboxes and open an excel sheet and show the datas in excel. the program works in my pc properly. but when i tried it in another pc it does not work. gave me the error "Row height must be 0 - 255 characters long" what is the problem i didnt find. i load the runtimes of microsoft office to another pc. what was the error or what didnt i do?
-
i did a project that takes datas from the texboxes and open an excel sheet and show the datas in excel. the program works in my pc properly. but when i tried it in another pc it does not work. gave me the error "Row height must be 0 - 255 characters long" what is the problem i didnt find. i load the runtimes of microsoft office to another pc. what was the error or what didnt i do?
Hi, See this Excel Help forum thread: http://www.excelforum.com/excel-programming/377761-adodb-is-unable-to-copy-more-than-255-chars-in-excel-cell.html[^] But to completely avoid this kind of issues, I recommend you try GemBox.Spreadsheet .NET Excel component for reading and writing XLS, XLSX, ODS, CSV and HTML files. It uses it's own engine to parse and write Excel files, and because of that it is 250x faster that Excel Interop and it doesn't have interoperability issues like Jet OleDb drivers for Excel.