Open WPF Application from Excel VSTO project

I have VSTO Excel tool written in C# and I use WPF form to display some data. WPF form is in a different project, but in the same solution with Excel VSTO project. If I open the WPF form in the same thread with Excel, it somehow damage Excel and it s...
more »

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

C # Excel Data Can I overwrite an existing file?

Can I open an Excel file, display it in the datagridview, and overwrite the data in the DataGridView when I save it back to an open Excel file? I only found a way to create and save new files and new sheets. But the way I want is not to create new ...
more »

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

Find and Replace Multiple fields?

I am struggling to find a solution for my issue. I have two excel documents, one with fields of "existing email addresses" and the other with "new clients email address" I don't want to send an e-mail to the "existing email addresses" so i need to ...
more »

2017-09-07 12:09 (1) Answers

Excel VBA Saveas function corrupting file

When I try to save my file with the ActiveWorkbook.Save function. The file get's corrupted and i cannot use it anymore. I already tried the ActiveWorkbook.SaveCopyAs function, but the result is the same. Below the example. I have added the 2 other f...
more »

2017-09-05 10:09 (1) Answers

Writing and Reading excel files in C#

I am writing a program that takes data from a website via selenium web driver. I am trying to create football fixture for our projects. I am so far, I accomplished to take date and time, team names and scores from the website. Also still trying writi...
more »

2017-09-02 12:09 (2) Answers

VBA first array item is always empty

The code below I patched togheter from several examples I found online, I am no VBA expert. But the first item on the clist array (and the first item on the dropdown) is always empty, I'm assuming it has something to do with the redims, but I couldn...
more »

2017-09-01 21:09 (2) Answers

VBA Find All Cells Containing and Copy Adjacent

Good morning all, I have been trying to find a thread on here that would cover my situation but I have been unsuccessful. I am trying to search for all cell containing a specific string value (if possible multiple strings e.g. "*Text*Text*" that ...
more »

2017-09-01 09:09 (2) Answers

Java - Eclipse to Excel from SQL Query

Getting the results of a SQL query where I want row 5 from every record that is returned. I would like to export the data to an Excel spreadsheet in rows of thirteen, starting at the second row (I have headers). My SQL logic is obviously off right ...
more »

2017-08-30 21:08 (1) Answers

ASP.NET - datatable to excel - change date format

I am generating xls file from ASP DataTable: var excelGrid = new DataGrid { DataSource = dataTable }; excelGrid.DataBind(); Response.Clear(); Response.ContentType = "application/vnd.xls"; Response.ContentEncoding = Encoding.GetEncoding("iso-8859-1")...
more »

2017-08-30 14:08 (2) Answers

XML unexpected characters

I have a XML file that I'm creating with an Excel macro by concatenating strings. The concatenation with the code is like: xmlText = "<?xml version=""1.0"" encoding=""UTF-8""?>" + vbCrLf And the final creation of the file is with the code l...
more »

2017-08-28 09:08 (1) Answers

Find value that is two characters different

Can anyone help i have a spreadsheet that has item codes in the same column and i need to find an item code that is just two charscters diffetent to the first. I.e. i know which row dftca0004 is and need to search for the row that contains dftea0004....
more »

2017-08-25 12:08 (2) Answers

Delete rows that do not contain string

I am trying to search a table generated by another module and remove rows that do not contain the string "REPAIR_RTS". I have tried several methods from this site but I get type mismatches every time I change the search value to "REPAIR_RTS" (the lin...
more »

2017-08-19 20:08 (2) Answers

VBA Excel open Subversion (SVN) file

I have an Excel VBA macro which opens files in multiple subdirectories one at a time, parses them, and extracts certain information to display in an Excel sheet. It also saves the subdirectory names in an array for use elsewhere in the macro. Curren...
more »

2017-08-18 17:08 (0) Answers

If find a date, then do...- VBA Excel

I struggle with one simple code that does not cooperate with me ;) I have in the column L some dates beginning from the row 5. The dates are in format yyyy.mm. but in the formula bar is visible the whole date in the format dd.mm.yyyy. In column F ar...
more »

2017-08-11 15:08 (2) Answers

PHPExcel Save file performance

I'm generating an excel file containing about 60000 rows in my php script. It takes about 18 seconds to generate the required data and write to objPHPExcel object but when saving it to a local file or sending back to the server it takes more than 30 ...
more »

2017-08-09 01:08 (0) Answers

Using find on multiple worksheets in excel

I have two files, I want to connect "FileA" to "FileB". FileA is a large table with column N being the date. In FileB I have multiple worksheets each with mini tables with the same format as FileA. I want FileA to self populate when FileB is up...
more »

2017-08-02 20:08 (0) Answers

Is there a way to call a python code in Excel-VBA?

I have an excel file(Main.xlsm) containing macros. I have a python file(python.py) to generate a subsidiary excel file(sub.xlsx) which i would further call in the macros of Main.xlsm file. This sub.xlsx file which is generated by the run of python.py...
more »

2017-07-31 09:07 (3) Answers