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
17 views
Adding data to the new worksheet added in PHP pear xls writer
I have created a workbook whose number of worksheets are
depend upon number of column in data.
The problem which is occurring is that, I have some data
which is more than number of columns available ...
0
votes
1answer
10 views
creating a complete array from different parts of strings and removing duplication in perl
I am having an issue aain.
I think I am just tired, because my brain does not want to think anymore.
anyway.
I have multiple strings which I collect from a spreadsheet, each string has the same layout ...
0
votes
0answers
9 views
Export multiple html tables to multiple excel worksheets using javascript
Hello i have an html page with multiple tables generated from a mssql database.
I'm using this code
var html = "";
$('table').each(function(){
html +=this.outerHTML + ...
-1
votes
0answers
5 views
Publisher Subscriber model emails using c#
I have to create a tool with the following specifications ?
1)A portal where users can go and subscribe
2)Subscription is for few reports
3)Here reports are not fixed , they are generated as per ...
azure
0
votes
1answer
10 views
skip empty cells in combobox vba
i am trying to create a combobox in vba wich get its data from a column in a sheet called "data" ,the problem is that it shows empty cells. The code that i used for that so far is :
Private Sub ...
0
votes
1answer
23 views
Splitting a semicolon-separated string in an Excel function
Is it possible to create an Excel-Function to split a semicolon-separated string to n adjacent cells?
I can create a function which does the opposite (concat the values of n cells via semicolon and ...
0
votes
1answer
22 views
Change file format from .xls to .csv using PHP
I'm new to PHP and don't know how to convert .xls file to .csv. I want to update my mysql database automatically, so I downloaded the data in a file named update.xls. I want to convert that file to ...
0
votes
0answers
11 views
Excel PowerPivot pivot table filter search performance issue
I have a PowerPivot model with a dimension table with ~1 million rows, along with 4 fact tables and several other dimensions. Total file size is ~130MB.
I create a pivot table on this model and add ...
-1
votes
0answers
12 views
Export java to excel with popup window [closed]
I have a java bean code. This code has been successfully exported to an excel file, but I want a pop up window (Open, Save, Cancel) appears before download to hard drive. (I write this to give action ...
1
vote
1answer
23 views
excel and sql queries through different subs or functions
I have an excel sheet which i use with an access database. I want to open the database and use different sub routines with different queries.
However i don't know hot to publically assign an variable ...
0
votes
2answers
27 views
Excel macro to fill a matrix with sums from cells across sheets with conditions
I have an excel workbook with on sheet for each day (not all consecutive days) , that looks like ExampleSheet1. All sheets contain an empty list events, each with a unique ID and a Name. If the event ...
0
votes
1answer
15 views
Could not load file or assembly 'Excel, Version=2.1.0.0, Culture=neutral, PublicKeyToken=93517dbe6a4012fa' or one of its dependencies
I have an MVC application that has been running in debug mode with no problems. Suddenly today I get an error when loading the browser screen (it compiles OK) that cannot find assembly "Excel" which I ...
1
vote
2answers
32 views
Ctrl-End doesn't bring me to the last cell [closed]
Ctrl-end key is supposed to bring me to the bottom, right-most cell. However, on several cases, it goes beyond that, meaning it goes hundreds of cells down, even if there are actually no data on those ...
1
vote
0answers
8 views
Spread sheet (like Microsoft Excel) viewer as a service in company LAN
Is there framework/ready-to-use system, that will let open *.xls, *.xlsx files in a browser.
For example http://officeviewer.company.com/file.xls
For desktop there is free Excell Viewer from ...
0
votes
2answers
19 views
Not possible to open excel documents after open a document in WebBrowser Control
I am developing a windows application to merge two excel files and then view the result in webBrowser control.
I have done this but i am not able to open other Excel files after open the merged ...
