is there a workaround to use the cfdocument tag to save a page/file as an excel sheet instead of a PDF file? I already have a process set up to make pdf files and email them out and would like to give my customers the option of getting an excel file instead. It would be nice if I could reuse the code I already have instead of having to ...
Hi all. Can anybody help me? How can I read only first row from an Excel file with OleDbDataAdapter? I know how I can read all data from any spread sheet: var dataAdapter = new OleDbDataAdapter("SELECT * FROM [" + sheetName + "$]", oledbConnection); But I don't know how can I do this for one row. ...
Any help is appreciated: I'm developing a C#.Net app in VS2010 that interacts with Excel. The app works correctly on my local machine. Uploading to a remote Windows 2003 server however, breaks the app. Originally, I received the following message Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-00000...
I need to help to generate column name from excel automatically. I think that: we can do below codes: CREATE TABLE [dbo].[Addresses_Temp] ( [FirstName] VARCHAR(20), [LastName] VARCHAR(20), [Address] VARCHAR(50), [City] VARCHAR(30), [State] VARCHAR(2), [ZIP] VARCHAR(10) ) v...
code: <?php /** PHPExcel */ require_once '../Classes/PHPExcel.php'; /** PHPExcel_IOFactory */ require_once '../Classes/PHPExcel/IOFactory.php'; // Create new PHPExcel object $objPHPExcel = new PHPExcel(); // Set properties $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") ...
I have an CSV export from an application, where the number values are formatted: 123[]456,78 where [] is a non-breaking space ( , ALT-0160, etc) Excel is not accepting this as a valid thousands separator. It will accept 123_456,78 where _ is a space, but not the non-breaking space character. Short of changing the Regional Settin...
Dim arr As New Collection, a Dim aFirstArray() As Variant ...some code For Each a In aFirstArray arr.Add a, a Next i get this error: This key is already associated with an element of this collection on this line : arr.Add a, a what am i doing wrong? ...
I'm trying to change the value of my checkbox to true based on a another cell's value if range("A1").value = "green" then Checkbox1.value= true end if How to I change the value property to true for multiple checkbox at the same time For some reason the code that i've tried doesn't do anything at all. P.S. I'm using format checkbox...
sub main() '''some more code''' For j = InStr(1, stext, " ") To Len(stext) If IsNumeric(Mid(stext, j, 1)) Or IsAlpha(Mid(stext, j, 1)) Then letter1 = Mid(stext, j, Len(stext)) Exit For End If Next j '''some more code''' end sub i am walking through line by line. as soon as the macro g...
I have an Excel spreadsheet, and I want to put a button on it, so users will be able to upload their data to an http/ftp server, or send the data to the server using a socket directly. I have noticed that some people creates an ftp script to do. First of all, I'm not sure that everybody has ftp on their Windows machine, and secondly, I w...
I wrote code to send an SMS using my GSM phone which is attached to the computer through COM port. The code is below. The problem is I do see that it is in the outbox of the phone and it actually appears to have been sent, but when I contact the recipient they say that I have not received the message. I test the phone, and I create and...
Hi I wanna check inserted value in excel cell and if value is higher than something(for example 3000) excel don't accept value(also throw error). So how can I do this? ...
I have an Excel workbook which contains a PivotCache I would like to use as a data source. var file = @"Foo.xls"; var excel = new Excel.Application(); var workbook = excel.Workbooks.Open(file); Excel.PivotCache cache = null; foreach (Excel.PivotCache pivotCache in workbook.PivotCaches()) { if (...) { cache = pivotCache;...
Hi, How can i perform to enter username and password when want to pull data into Microsoft Excel with web queries??? Have any solution can be used to solve this kind of problem? ...
I want to generate excel with enabling auto-filter option.For that I have create one template excel file by enabling auto-filter option but when I write something into that template excel file auto-filter option disabled again. Is there any solution to create excel file by enabling auto-filter option. ...
I am trying to make a C# Excel add in change the parameters of an array formula in-place; i.e. do the same as a user modifying an array formula and hitting ctrl-shift-enter. Setting the activeCell.FormulaArray property does not achieve this; it throws a 'You cannot change part of an array' error. Does anyone know how I can achieve this...
I am using the following code for uploading keywords & count to an Excel file. I am having the keyword_id as primary key for that one. I am having the two columns in the Excel file. 1.keyword and 2.count my code is: while (rs.next()) { System.out.println("inside "); String keyword = rs.getString(1); int count = rs.getInt(2...
I want to stop others from editing the cell contents in my excel sheet using VBA. Is it possible to do this? ...
Hi, I'm trying to merge two workbooks using JExcelApi (basically by importing all sheets from one workbook to another) : the sheets get merged correctly, unfortunatly the background of all cells is black, except for those which already has a background color. Some background colors get changed randomly as well (e.g. blue becomes red). ...
I have a criteria page in my asp.net application. When user clicks report button, firstly in a new page results are binded to a datagrid, then this page is exported to excel file with changing content type method. That normally works, but when large amount of data comes, system.outofmemoryexception is thrown. Does anyone know a way t...