Excel Import XML specific Nodes

I try to import some specific XML Nodes into Excel 2010. But i get some Errors. I want create a table with the content from the XML Node "Item" to make it easier to read. But there are some Problems the Error wich is defined later and that i dont wor...
more »

2017-11-13 10:11 (0) Answers

Read excel file and update adding a new row

I'm a beginner in java and I'm trying to do a little java program that read an excel file, and update the file adding a new row at the end. Then read again and update with a new row ecc, ecc.. This is the file I read (boh.xls): click here to see t...
more »

2017-11-12 23:11 (1) Answers

Result of SSIS Merge Join

I have two data sources - Document and Customer and I want to join them, creating rows that that information both from documents and customer, having the customer_code as key. Finally, I get only 58 out of 30k results that I expected. Where is the...
more »

2017-11-12 19:11 (1) Answers

Excel find cells that partially contain a number

I Would like to return a value if a cell partially contains a number: Example: Range: A1 = 90003 B Search value: B1 = 90003 Return: (This is what I want) C1 = Yes I have tried something like =IF(ISNUMBER(SEARCH(A1,B1)), "Yes", "No") But thi...
more »

2017-11-10 08:11 (1) Answers

SSIS Excel File issue - Failure creating file

I have SSIS package that grabs excel file and load it to sql table .i get the following error when i run it. I have tried to make run on 64 bit to false. That did not work i also have installed 64 bit access driver engin . That did not help either....
more »

2017-11-09 22:11 (1) Answers

Excel VBA - Find on merged cell

I am not able to using VBA find function on a merged cell. If I unmerge that cell, it finds that cell correctly. Is there any solution to this? Private Sub FindTry() Dim oFind As Range With Sheet2 Set oFind = .Cells.Find("/", , xlVa...
more »

2017-11-09 12:11 (0) Answers

Can Excel's INDEX function return array?

If the data in the range A1:A4 is as follows: Apple Banana Orange Strawberry Then INDEX can be used to individually return any value from that list, e.g. = INDEX(A1:A4,3) Would return Orange. Is there a similar Excel functions or combination o...
more »

2017-11-08 20:11 (3) Answers

Embedded Excel 16 Window In WPF is not focusable

I try to embed excel 16 (office 365) window inside WPF application. It is working perfect with Win32 api, but for some strange reason, after opening context menu with right button click from embedded excel file, focus can't be set on any cell anymore...
more »

2017-11-03 15:11 (0) Answers

Count number of times specific text is in an array

I have a list of annoyingly non-standard data, the titles of trouble tickets, that I need to find a way to standardize into categories and then count the number of cells that fall into one of the categories. I have been attempting to use the followin...
more »

2017-11-02 18:11 (2) Answers

Saving big xlsx files pandas python

I am trying to connect 20 excel files into one and save it to excel. It should be in one sheet. My idea so far was to read all the files into dataframes, concat them and save to excel. After concatening I have a dataframe which shape is (1245226, 20...
more »

2017-11-02 14:11 (1) Answers

c# Export datagridview values to excel

Any one help me to with this problem, I can't really understand, I'm using this link application for this program, and this problem always appear. Hhere is the link that I'm trying to do http://www.aspdotnet-pools.com/2015/03/export-gridview-dat...
more »

2017-11-02 03:11 (1) Answers

Database with multiple values for the same ID

I have a database where each entity has a unique ID, but recently all of the entity names were changed (not in the same way) to improve readability. These changes aren't standard across the different names and vary from ID to ID. This has made a lot...
more »

2017-10-31 22:10 (3) Answers

Disable Excel 2016 "Share" on specific document

Is it possible to disable the Excel 2016 "Share" option on a specific document only? I have previously used CustomUI XML to remove all unwanted ribbons buttons etc. for a specific document that I don't want users to send to others or to save locally....
more »

2017-10-25 14:10 (0) Answers

Combobox with list find function additem vba excel

Im trying to do a Combobox on VBA Excel that add items depending on the return of find function that look's if what i wrote exist in my worksheet and show the liste of all words that start with what i wrote. To be more clear, i want to create a kind...
more »

2017-10-25 12:10 (0) Answers

VBA other Workbook Doesnt close Properly

Hi there My VBA code does not want to close my Raw data File properly. I have a data capture form then , When I hit Submit, Opens another Excel File, Copies all the data into it and is supposed to save and close the workbook. My code is as follows: ...
more »

2017-10-24 15:10 (1) Answers

Reading excel file in Reactjs

I am trying and banging my head already while trying to read excel file in Reactjs. I have tried multiple libraries out there like, Sheetjs , excel-parser, exceljs and so on (like 8-9) libraries. I am getting weird and different errors in every l...
more »

2017-10-24 13:10 (2) Answers

Python URL command export to .xlsx file

I have one command that gives all urls of my project. And i want to export this command to xlsx file. Any ideas? In print message should be url command Thanks guys in advance. urls.py (Here command that gives all urls) from django.conf.urls impor...
more »

2017-10-20 15:10 (1) Answers

Find and Replace using OpenXML

I have a Excel Template (XLTX) where I have some place holder like {{ReplaceValue1}} {{ReplaceValue2}}.....{{ReplaceValueN}}. I wanted to find all these place holders using regular expression "{{*}}" and replace this with the corresponding values us...
more »

2017-10-19 23:10 (0) Answers

c# wpf importing excel performance

I'm importing a large excel file that can vary in length (250+ columns * 100,000 rows), it holds columns of data, where amount of columns and their names can change, rows are also variable but they are the values. I'm using Interop to pull the data ...
more »

2017-10-12 21:10 (2) Answers