Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it [tag:excel-vba]. If it is about an Excel formula or worksheet function, then also tag it ...
0
votes
0answers
4 views
Nested VBA Excel For Loops not showing all Data
I have 2 list of names that are in different orders. One list has data that will need to populate the other list based on the employee's name. I have a nested loop that should be matching names from ...
0
votes
0answers
9 views
visual studio resources vb.net image to string?
Hey so i wonder if there is a way I can add a picture to my project > done this
Then add to an excel file ( wich uses only string location of file path)
and grab my resource file ( and its string ) ...
0
votes
0answers
6 views
Excel Macro Graph Removing Blank Legend Keys
Option Explicit
Public PlotName As String
Public PlotRange As Range
Sub Tester()
Range("TCKWH.V.1").Select
AddPlot ActiveSheet.Range("KWH_G_1")
End Sub
Sub AddPlot(rng As Range)
With ...
0
votes
0answers
7 views
Running python script with cxfreeze not working
My setup.py script is
import sys
from cx_Freeze import setup, Executable
build_exe_options = {'packages': ['re','sys','time','win32com.client','pypyodbc']}
base= None
setup(
name = "myapp",
...
1
vote
0answers
13 views
Excel VBA: Formula is too complex for object
This may seem like a simple problem, but it's been very frustrating. I've written a couple (relatively simple) macros in VBA for a spreadsheet that I want to make very user-friendly.
In other words, ...
0
votes
0answers
11 views
Reading VBA property set with C# within VBA workbook event
I have a C# VSTO / VBA hybrid project.
When a user opens a valid Excel workbook using my VSTO app, a VBA property is set from C# as such:
worksheet.GetType().InvokeMember("AddInIsLoaded",
...
0
votes
0answers
10 views
Excel Automation Windows Service
I have a Windows Service that runs the Excel Interop in order to automate the execution of various macros. However, I am running in a peculiar issue when I try to run a macro which access a database ...
-1
votes
0answers
14 views
need to write a vb program so that the excel generated files can be automatically loaded in to sql database
I have to write a code for exporting all the excel file present which are a lot, to SQL database and next time a excel file is generated the user only has to upload it and it is transferred to ...
0
votes
1answer
11 views
Excel macro to search for text then Popup box if found then display number of times word appears
Can someone help me alter this code so that when it finds the word it will also display the number of times the word appears? Thanks!
Sub findtext()
'
' findrobot Macro
' Will find the word robot
'
' ...
0
votes
1answer
18 views
Excell cell reffering indirect
Let's say in Excel in cell "A1" I have the following formula:
=TRIM(CLEAN('SomeSheet'!A8))
Now, I would like to reffer 'SomeSheet'!A8 from another cell e.g. from cell B1.
In another words: B1 -> ...
0
votes
0answers
4 views
Find rows matching criteria in a cell in another worksheet and copying & pasting into another worksheet
I'm trying to find all the rows in worksheet DATABASE where the value in Column A matches the value in worksheet Daily Report, cell C5, and copy columns BP thru BW in worksheet DATABASEand pasting ...
2
votes
2answers
18 views
Excel Test Length of 1 field and divide if len>200
I have column B that I need to test the length to see if it is longer than 200 characters. If it is longer than 200 characters, I need it to go from right to left and find the occurrence of the ...
0
votes
1answer
4 views
Excel--Add Text to CellA1 after evaluating contents of A1
I would really appreicate help this.
I have a column with dates and times. Ex.
10/10/2012, 12:55
10/5/2012, 17:24
10/2/2012, 17:42
9/27/2012, 16:28
9/22/2012, 23:38
I want all of the dates in ...
1
vote
0answers
10 views
Excel named ranges to treeview (treestructure) with C# / VSTO
I have an Excel sheet with many named ranges. Now I want to visualize the hierarchical structure of all named ranges in a treeview (with VSTO / C#). What would be the best and effective way to parse ...
0
votes
1answer
16 views
using VBA for a pie bubble chart in excel
I wanted to use the following code to create a bubble pie chart in which the bubbles are pie charts.
Sub PieMarkers()
Dim chtMarker As Chart
Dim chtMain As Chart
Dim intPoint As Integer
Dim rngRow ...
-1
votes
0answers
21 views
Read/Search/Create/Send excel file in C#
I need to know what would be the best approach to achieve this:
Let say I have a Excel file with a few sheets inside.
I want to load Excel file in the C#, search for multiple words, if they occur in ...
0
votes
2answers
13 views
Using Worksheet Macro to hide FALSE Row
I am trying to hide the Rows that are false.
Currently I have
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Range("B10:B13") = False Then
Target.EntireRow.Hidden = True
...
0
votes
0answers
11 views
2-Way Table Look Up in Excel Using VLOOKUP and MATCH Returning Error
I'm working an a cell formula that will perform a 2 dimensional look-up on table.
My the formula is as follows:
=VLOOKUP(A97,A4:L10,MATCH(B96,A4:L4,0),FALSE)
However, it is returning a #N/A error. ...
0
votes
0answers
5 views
SSIS error when importing excel date column and feeding to Slowly Changing Dimension
I'm hoping someone that has come across this can help me out because I'm pulling my hair out here.
I have an excel sheet that has a bunch of columns, one of them being a date column. When I use an ...
0
votes
3answers
14 views
number to date conversion in excel (weird format)
I have collected some details from sql and it shows a birthdates as following (each line represents a different birthdate):
-294022800
649119600
-138675600
49158000
32396400
631152000
-2147483648
...
0
votes
0answers
17 views
Building an Inventory Database in Excel
I have been asked to build a inventory checklist in Excel. There are over a 100 products and the chart is suppose to keep track inputs of purchases to inventory, thus adding to the inventory number of ...
-1
votes
0answers
20 views
Programically select every nth row and mth column in Excel
I have a worksheet which stores the performance data of my research
|| Preprocess1 || Preprocess2 || Preprocess3...
|| param1 | param2 || param1 | ...
0
votes
1answer
15 views
input box to populate excel formulas in a file
I would like to create a Python script which would open the csv (or xls) file and with an input box I could copy and paste the Excel formula to the specific row...then apply this to the rest of the ...
0
votes
1answer
28 views
How to enter password in XLS files with python?
So I have a password protected XLS file which i've forgotten the password for...I'm aware it's a date within a certain range so i'm trying to write a brute forcer to try various dates of the year. ...
-2
votes
1answer
24 views
Excel VBA - adjust number of rows based on change in cell value [on hold]
Could you please give me a hand with following problem:
I have a dataset in rows 106 to 109. In Cell A102, I have a value that's currently 3. Rows 103 to 105 are empty.
I'm looking for a VBA code ...
0
votes
1answer
35 views
How to transform linebreaks inside MySQL column data into \n? [duplicate]
The column data is fed by a textarea html element in the web page ; so the user can enter linebreaks within it. When I put the column data inside an excel file then excel does not recognize the ...
0
votes
2answers
28 views
How to use Do Until loop in VBA to select first row with the current date
I have an excel sheet with dates at the beginning of each row in the format of 6/27/2013. I would like to be able to select all rows in the sheet that begin with today's current date, so I wrote the ...
1
vote
1answer
19 views
Setting Column Headers When Adding Columns To a Table Via Macro in Excel
So I'm working on this macro that automatically adds columns to a table based on other columns in the table. So here's the functionality:
I have a number of columns in this table headed "CY 2010" - ...
-1
votes
2answers
21 views
=Counta recognise 0.5 conditional formatting as half
I've conditionally formatted a row so that when you put H or S or P in it changes colour.
At the end of the row I have done the =Counta formula so that I can get the total.
The problem is I also ...
0
votes
2answers
14 views
(Excel 2010) Hyperlink to file in same directory as xlsx file
I am trying to add a hyperlink to an Excel cell that leads to a file that is on the same directory as the xlsx file. I achieved that with this
=HYPERLINK("file.ext")
but the cell looks like this
...
0
votes
2answers
27 views
MSSQL Database Query with PHP
I need to get some data from a Microsoft SQL Database at work. When I have the data I need, I need to make an Excel Spreadsheet that can be saved locally on my computer.
I found PHPExcel which seems ...
0
votes
0answers
17 views
XLL add-in Development - Excel SDK function issue
Currently I'm developing an Excel 2010 add-in with the Excel SDK 2010. Unfortunatly is there little documentation from Microsoft ( or i just didn't see it so far). I reached the point that my add-in ...
0
votes
0answers
6 views
NPOI Set autosize column to readed excel
I've found a lot of questions about the autosizecolumn of NPOI library, but all the questions are about a new document created with this library.
My scenario is about an Excel file already created, ...
2
votes
0answers
58 views
getString() does not retrieve String bigger than 255 characters
Data are in my excel sheet which contains several cols and rows. When I read the data using ResultSet string truncated 255 char.
Connection xlsConn = ...
0
votes
1answer
23 views
Reading each line of a text file into VB
I'm looking to automate some work that I currently have to carry out.
I currently receive a number of machine names that I have to query in unix from config files, but I have to amend the list I ...
0
votes
2answers
17 views
How do I copy one specific word, that shows up in multiple rows of column A, and paste it into column B, in the same row?
The scenario in Microsoft Excel:
Column A
Row 1: This is a sentence with a SPECIAL word.
Row 2: This is another with a SPECIAL
Row 3-3,000 <-- does the same thing ... Every now and then, there ...
0
votes
2answers
19 views
Excel data are strange when MySQL column data has breaklines
I exported MySQL columns data into an excel file through the download concept using the header mechanisms. The problem is that if a column having text as its datatype has data containing breaklines ...
0
votes
3answers
44 views
Excel get value from worksheet using value (complex)
This is quite a hard situation and I am wondering if it will be best to use a formula or vbscript. I will explain it first and maybe someone can help me come up with a way of doing it.
I have 2 ...
0
votes
0answers
15 views
How to display Russian characters exporting from php to tab separated (as if excel) file
Here is simple code to export php to excel
$filename ="excelreport.xls";
$contents = "русский \t testdata2 \t testdata3 \t \n";
header('Content-type: application/ms-excel');
...
1
vote
0answers
17 views
Export data from SqlQuery to Excel sheet
I have the below Query and would like to know how do I import the results to an excel sheet from Sql server
This is what I have to import
select c.description as 'provider',
b.lastname, b.firstname, ...
0
votes
0answers
16 views
Sorting data from excel spreadsheets into new files
so my issue comes from the excel data I currently have which I need to convert into 4 separate forms, each with different details. The specfics don't really matter, but what I'm trying to do is code ...
0
votes
0answers
24 views
Data fetching from excel sheet when the data is in matrix format
Now, I have an excel sheet, where I am updating stocks of items in various warehouses. My item codes are in row format(around 8000lines) and the warehouse are in column format(32 warehouses) and the ...
0
votes
1answer
17 views
Use cell value as part of a reference to a cell range in a formula
My problem is similar to that in this quesion: Row in formula change based on value in another cell, i.e. I want to use the value of a cell as reference to another cell in a formula of yet another ...
0
votes
1answer
24 views
How to search excel files fast in C# for Windows Mobile device
I need to write an application in C# (VS 2008) that will search in a relatively large (80K rows) excel file for a specific row. I would normally use ADO.net, but Windows Mobile doesn't support this. ...
-2
votes
0answers
25 views
Trying to add two worksheets into same execl file but it's adding only one sheet
protected void btnExportExcel_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", ...
0
votes
1answer
12 views
Excel NETWORKDAYS - Do these returned values look more reasonable?
Do these returned values look more reasonable for NETWORKDAYS?
2013/6/26 Wed
2013/6/27 Thu
2013/6/28 Fri
=NETWORKDAYS("2013/6/27","2013/6/26") = -2
Should above better return -1?
...
1
vote
0answers
26 views
Reading the contents of excel file
I am using JDBC to read an excel file which is in table format.
I was quite successful in doing that. But, one of my coulmns has link to external file sources. I was able to get, the name of link, ...
0
votes
1answer
21 views
PHPExcel Sumif and Skip
I just want to ask if there's a function in excel/phpexcel that can SUM a range of
cells but skip to add every one cell.
Ex. Range is A1:G1 and it will only sum A1+C1+E1+G1 skipping every 1 cell.
...
1
vote
5answers
73 views
How to increment letter combinations in c++ beyond 'z'?
I'm working on an Excel spreadsheet, and I have to use only one type of formula for a huge amount of data. Since in the formula the only necessary changes concern letters, I was wondering if there is ...
0
votes
2answers
11 views
I am writing a windows forms app in VB.Net to open Excel worksheets but I can't get the references/import statement to work
I am writing a windows forms app in VB.Net to open Excel worksheets but I can't get the references/import statement to work. I have seen some working code which has the reference Microsoft.Office.Core ...
