Dead silence! Not often you experience that on Stackoverflow... I've added a small bounty to get things going! I've built a json document containing information about the location of various countries. I have added some custom keys. This is the beginning of the json-file: { "type": "FeatureCollection", "features": [ { "type": "Feature"...
Hi. I would like to open a connection to SQL database, and then have access to individual cells. I have an example that uses PivotTableWizard (presented below). I would like to know of a way that does not have anything to do Pivot Tables - I would like to iterate cell-by-cell. Or is this PivotTableWizard suitable for that purpose also? ...
Basically I've coded an Excel 2007 project in VB.NET 2010 that allows you to create charts with a fair amount of interactivity. I want the user to be able to save and reopen this workbook and still have that interactivity in any already-created charts, so they don't have to re-create them. When I create the charts, I use Sheet1.Controls...
I want to create an 'universal' XML spreadsheet compatible document... Something compatible both with Microsoft Excel and especially with the open source alternatives (OpenOffice Calc, Gnumeric, ..). There's an issue I encounter when I try to border some cells. This is how you do it in Excel: <Border ss:Position="Bottom" ss:Line...
Is there any way to hook into the creation of a named range or list object in Excel 2007 using VSTO? I need to track the named ranges in a worksheet and, as such, need to be alerted when a new one is created. I have tried the SheetChange and SheetCalculate events and neither is triggered on the creation of a new named range. ...
While I do understand php, I'm more of a sysadmin than a programmer. Add that I really hate HTML and never used AJAX nor javascript :) I'll have to do a php page that gets data from an HTML form and sends it as an Excel attachment via email. Of course I'd like to reuse as much code as possible from already-made solutions. It's kind of "...
I have a list of items - each item has a title, plus a bunch of attributes, including a date. If I drop the date into the row box of a pivot table, then group it, and drop the title below - so I have Years, Quarters, Created On, Title, I get a nice list of all the titles in my data, grouped by year, quarter and month. But I want to als...
I have 2 separate sheets, lets call them sheet A, sheet B. I have data in sheet B which is also in sheet A. I want to find those rows that are equal and remove them from sheet B. I cannot combine the 2 sheets and use filters because I'm doing dynamic SQL to query different data. Each sheet has a unique key column I'm ok with VBA sugg...
I have embedded a number of ActiveX controls in an Excel 2007 spreadsheet. Is there a way from VBA code to access the tab order assigned to a control so that the controls can be tabbed through in a particular order? The ActiveX controls I have inserted tab through in the insertion order, but this is not correct after changes have been ma...
SERVER A: public string connStr = "Data Source=PH-09-5336;Initial Catalog=InventoryDB;Integrated Security=True"; SERVER B: public string connWIP = "Data Source=PWODU-COGNOSDB3;Initial Catalog=BI_SOURCE; I have this method of inserting records to InventoryDB.DBO.FG_FILLIN from excell file. Select records from BI_SOURCE.dbo.ODU_WIP_PI ...
Hello, i put the name of the files i want to perform in some cells and wrote a maco for excel to call up the file according to the location. (lets say I write 1.xls in cells Cells(2, "B")) e.g. A = Cells(1, "B") B = Cells(2, "B") C = Cells(3, "B") Workbooks.Open Filename:=A Windows(A).Activate Now, i want to do VLOOKUP by looki...
Hello All, I am reading excel file using Microsoft.Office.Interop.Excel. It works fine in all the case but in some case like superscript or subscript, its not working! CM2 - Here 2 is superscript, but i am getting CM2 not cm2 [cm-square] Any help in that direction will be appreciated. Imran ...
Hi all; my excel |Name|Telephone| |Color|Car| |John|Jon| i need "|John|Jon|" how to select OleDbCommand? third row start My Csharp Not Work Code: ExcelCommand.CommandText = @"SELECT * FROM " + SpreadSheetName + " Where RowNumber > 3"; Thank you... ...
Hi, I am trying to export a dataset to excel from asp.net page method(webmethod) using the following code. [WebMethod] public static void ExporttoExcel() { DataSet ds; productfactory pf=new productfactory(); ds = pf.getproducts(); HttpResponse response = HttpContext.Current.Response; // f...
I want to limit the result to only square numbers ( I am using excel plugin). How do I enforce this? As in, Minimize Goal X subject to a condition that X is a square number. ...
I have some data that's currently stored in an Excel workbook. It makes sense for the data to be in Excel (in that it's easy to manage, easy to extend, do calcs, etc.) but some of the data there is required by an automated process, so from that point of view it would be more convenient if it were in a database. To give the information m...
Hi all, I am using the following code to export a datset to excel sheet. [WebMethod] public static void ExporttoExcel() { DataSet ds; productfactory pf=new productfactory(); ds = pf.getproducts(); HttpResponse response = HttpContext.Current.Response; // first let's clean up the response.o...
I want to add a sequential number in column 1 (so A1, B1, c1, would be 1,2,3) WHEN I enter any data in Column 2. So if a cell doesn't have a value, nothing is entered in the other cell. The end result should look like this. A- 1 32 B- 2 18 C- 3 16 E- 5 20 It's for a box count and config. I've tried a few things and I ...
I am trying to create double and number format cells in excel using NPOI library. I used code like Dim cell As HSSFCell = row.CreateCell(j) cell.SetCellValue(Double.Parse(dr(col).ToString)) In excel numbers are aligning right but when I check format it is showing in "General" then I changed my code to like below Dim cell As HSSFC...
This is related to http://stackoverflow.com/questions/3419573/excel-vba-remove-duplicate-rows-by-cross-referencing-2-different-sheets-then-de I can't seem to get any VBA to work well or fast enough for a couple 100 rows. Does Excel have a formula to remove duplicates from one sheet, by cross referencing another sheet? Thanks for all...