In my C# xll, I have a string array. I can read it from VB in Excel one element at a time, with the following code on c# side: public int NumColumns() { return _columns.Count; } public string ColumnName(int columnNumber) { return _columns[columnNumber]; } and this code in VB on Excel side: n = Application.Run("NumColumns") ...
In my C# windows application, I am exporting sql server data to excel on remote drive. But it is too slow. However, if I export data to excel in the local drive, it is fast. How can I increase the time if I want to export data to remote drive? Thanks in advance... ...
I have create name range on sheet "A" so I need to use this range as validation ComboBox on sheet B. I want to know how can I setting validation as range using C#? ...
Hi Friends! I have a requirement that , i have a table of 400 columns. Here i need to Export this table to Excel sheet. And i need to upload to Open Office Sheet. I do not have MS-office. This is in ASP.NET and C#.NET I am new to this concept. So please help me to solve this. And friends there is a problem , i have 400 columns , w...
I'm exporting a table of data to CSV format, e.g.: "COL1","COL2","COL3" "1","some text", "£232.00" "2","some more text", "£111.00" "3","other text", "£2.00" The code to export is fairly simple using an ashx handler: context.Response.Clear() context.Response.ContentType = "text/csv" context.Response.AddHead...
I am currently using Visual Studio 2008 for my ASP .NET application. I am trying to Export some reports with Japanese Characters to Excel via the Response object. When I try to Export, all the Japanese characters looks garbled. It works fine with Chinese Characters. Here is what I tried: I tried Installed Japanese Language Pack / Encodi...
I want to validate range of excel worksheet (e.g. "A10:B20") to check that is it has error or NA value or not? How to do that in C#? P.S. I find similar topic (Excel range usage question (cell error checking)) but that topic is not thing I need. ...
I'm looking to export data to excel from Delphi without having to own a copy of excel, is this possible? N.B. CSV will not do. ...
I want to create a validation range in cell "A1". This validation allow user to input value from 1 to x, while x refer to value user input in "B1". For example, if user input value 100 in "B1" then we can input only 1 to 100 in cell "A1". I want to know how to do this in C#? ...
Hi, I am using the below code to Export DataTable to MS Word,Excel,CSV format & it's working fine. But problem is that this code export to MS Word 2003,Excel 2003 version. I need to Export my DataTable to Word 2007,Excel 2007,CSV because I am supposed to handle more than 100,000 records at a time and as we know Excel 2003 supports for o...
Hello, I want to create & fill a .xls file using ADO.NET or LINQ, but I do not want to have the columns names in the first row. I just want to insert rows starting in row no. 1. I know I have to insert colums first, but... is there a way to 'hide' those columns headers? The problem is that, in first row of my spreadsheet, I must have ...
Hi guys, thank you for spearing some time;so here is the problem : I have a default excel template with sum formulas and function implemented in it. I want to transfer my grid data to that default template that would be stored on web server and after grid data has been copied to my default template I want user to be able to download that...
Hi All, How to set cell/column value dynamically using PHPExcel library? I am fetching result set from MySQL database and I want to write data in excel format using PHPExcel library. Looking at example $objPHPExcel->getActiveSheet()->setCellValue('A1', 'cell value here'); indicates that we have to hard code cell/column reference As...
We have a background process that calls Excel for generation of report spreadsheets. Occasionally, a crash or inadvertent server reboot will occur while Excel is running. The first launch of Excel after the restart brings up the dialog box (paraphrasing here) "Would you like to start Excel in safe mode?" (Yes/No) The issue is that our b...
I have a dataset and I write it's values to an excel file using Microsoft Jet 4.0 Oledb provider. I want to put hyperlinks into the excel, for this I write "=HYPERLINK("http://www.abc.org/x.pdf")" in DS and then write it to excel. But when the excel is opened it prefixes a ' (quote/apostrophe) before the formula and there it comes as a t...
I want to automate exporting the results of an Access query to Excel. My environment is: Access 2007 A database in Access 2003 format Export should be in Excel 2003 format. The query includes a Memo column that can contain up to 512 characters. So far I've tried the following: Run the query in Access, then copy/paste the result gr...
We have a SharePoint 2007 deployment which will have a substantially large document library. My client wants the ability to export this library to an Excel spreadsheet, but specifically wants the ability to divide the spreadsheet into several worksheets based on a specific field. Is this possible to accomplish in WSS 3.0, through the obj...
Summary: ASP.Net website with a couple hundred users. Data is exported to Excel files which can be relatively large (~5 MB). In the pilot phase (just a few users), we are already seeing occasional errors on the server in the exporting method. Here's the stack trace: System.Web.HttpUnhandledException: Exception of type 'System.Web.Ht...
I need to have three rows within the footer section of a column while generating an excel worksheet... My code follows > (e:column) > > (e:facet name="header"/) > (e:cell value="Header"/) > (/e:facet) > > > (e:cell value="cell 1"/) > > (e:facet name="foot...
My company has new customers in Brazil and we realized that our excel reports are not working when our Brazilian customers tried to open the reports in their Brazilian versions of excel. For excel output we use spreadsheet gear in our vb.net web application. Our excel worksheets are fairly simple. Mostly outputted text/numbers/dates, ...