The tag has no wiki summary.

learn more… | top users | synonyms

8
votes
2answers
352 views

What is a good design pattern for generating an Excel (xlsx) file in code?

I occasionally have projects where I have to output some data as an Excel file (xlsx format). The process is usually: User clicks some buttons in my application My code runs a DB query and ...
0
votes
0answers
4 views

redimension multidimensional arrays in Excel VBA [migrated]

Take a look at the following code. What my problem is is that I can't figure out how to redimension the n integer and the b integer. What I'm doing is the array sent1 is already working and it is ...
1
vote
3answers
178 views

Designs for outputting to a spreadsheet

I'm working on a project where we are tasked to gather and output various data to a spreadsheet. We are having tons of problems with the file that holds the code to write the spreadsheet. The cell ...
2
votes
4answers
2k views

Security Concerns with password storage in Scripting Languages (VBA)

The team I work with handles large amounts of consumer survey, and internal company metric data. Primarily the data is stored in a database, and we utilize various platforms and to work with that ...
2
votes
3answers
104 views

Can Excel be a strong development platform? [closed]

We are a group of enthusiast engineers who are developing a series of application using Excel as our front end. We are using VBA but plan to start doing in VB.net. Some people in IT have questioned ...
-1
votes
1answer
71 views

Choosing a file format to storage a simple text data [closed]

My .NET application makes its work and then creating a report (an Excel worksheet). The report holds thousands of short text strings [KEY - VALUE], so excel worksheets suites very well, one column ...
0
votes
1answer
90 views

Full Text Indexing Strategy for MS Excel Documents

Background As part of a broader application that allows users to search thousands of MS Office documents on a private network, I need to index and make searchable Microsoft Excel files. My basic ...
0
votes
1answer
62 views

Automatically analyze excel files

I have to replicate a manual generation of a large number of excel files. I started to manually track the relations between cells ( files, formulas, etc). I also had a talk with the person which ...
0
votes
4answers
2k views

How to insert/update a large amount of data into mysql using php

I have an excel sheet which has a large amount of data. I am using php to insert the data into mysql server. I have two problems 1) I have to update a row if the id already exists, else insert the ...
3
votes
3answers
4k views

Questions over Excel programming [closed]

I have always heard about the powerful programming capabilities of Microsoft Excel (not VBA, I am referring to the formulas of Excel itself), but have never seen it. Does it really have all that ...
0
votes
1answer
632 views

Guidance on Excel VBA resource scheduling algorithm?

This was posted originally at StackOverflow though suggested to post here instead. I am looking to create an Excel VBA solution that will create a rota/schedule allocating staff to service users ...
2
votes
1answer
141 views

How can I automatically test a large, complex spreadsheet?

So, I've inherited one of those "Engineer's Special" spreadsheets -- the kind developed by Mort the Engineer, with lots of hairy VBA and WTF, complicated calculations, and no documentation. ...
0
votes
0answers
185 views

Cost Benefit Analysis of choice of javascript framework for excel-like web app

I am engaged by a telco company sales team to develop a web application to replace their current workflow. Their current workflow consists of many spreadsheets containing product, pricing, and sales ...
-2
votes
3answers
5k views

How do I Export to excel on aspx page?

I am trying to take data that I request from an access database and put it into and excel file on the client computer. I usually use ajax to request a summary of the data I need. It is formatted ...
2
votes
0answers
334 views

Implement FBP / Dataflow programming in VBA?

Intrigued by Flow Based Programming a la J Paul Morrison. I wonder if one can implement FBP in Excel/VBA. I searched quite a bit for a Basic-Lang FBP implementation to no avail. I've looked at some ...
13
votes
2answers
1k views

Workflow: Using binary document formats in Git without locks (moving from subversion)

We're a software consultancy with a multitude of projects for different customers. We traditionally use Subversion, but are currently considering moving to Git. A significant portion of the documents ...
0
votes
3answers
2k views

Parsing excel data in java, before saving it to database

I'm working on some project where I have to make a database for data which is currently kept in excel files, so I have to do some changes before writing the data into the database. I'm going to read ...
1
vote
4answers
506 views

What are some non-MS languages that can write xlsx (Excel 2007+) documents efficiently? [closed]

Unfortunately, Excel format is required for the project I am working on. I have no problems getting the data I need in objects and arrays, and currently PHPExcel is doing handling the document ...
8
votes
2answers
561 views

What is the justification for Python's power operator associating to the right?

I am writing code to parse mathematical expression strings, and noticed that the order in which chained power operators are evaluated in Python differs from the order in Excel. From ...
2
votes
1answer
894 views

Best Practice - XML To Excel

I've to read a big XML file with a lot of information. Afterwards I extract the needed information (~20 Points(columns) / ~80 relevant Data (rows, some of them with subdatasets) and write them out in ...
9
votes
6answers
559 views

Software solution from the 2000's, should I attempt to patch or remake the whole thing?

I was sent out to discuss a system that a certain company is currently using and what should be done with it. The company manufactures various carton displays. This system was developed to keep track ...
-2
votes
6answers
12k views

How to create a cool user interface for an excel file in java or C#? [closed]

I have an excel file with many sheets and relations between theme (ie, formulas that relates sheets to each other). I wanna create the user interface for this excel file.in other words I wanna create ...
0
votes
3answers
257 views

Which programming designs leads to more problems?

As a fresh programmer, one of the first thing for me to learn was to learn language and its syntax. Now my next training issue is to design my code heirarchy in such a way it is simple to maintain ...
2
votes
2answers
154 views

Developing an Interface to a Dynamic System

I work for a small company and have been designing a GUI to interface our embedded system. The problem with this embedded system is that it is not a finished product (may never be) and is constantly ...
5
votes
1answer
477 views

Need advice for approach for a web-based app that loads excel worksheet but exposes only the charts

I'm looking for suggestions on the Visual Studio approach to take for a web application that is in the conceptual stage. My environment has a lot of tools: Windows Server 2008 R2 Standard 64bit ...
1
vote
4answers
2k views

How do I refer to the smallest possible non-zero value?

Back in my C programming days I thought there was a constant or function (I can't remember what it was called, let's call it SMALL) whose value was the smallest possible positive value. (Imagine the ...
4
votes
2answers
424 views

Alternatives to Project Euler for improving Excel ability [closed]

I've recently been enjoying using the mathematical problems listed at Project Euler to learn Python. My Excel ability is better than my Python, but I think I'd still benefit from the sort of inductive ...
2
votes
1answer
236 views

How can I migrate from Excel VBA with ADO to C++ with OCCI?

I am employed as a developer, but the only application development tools I have available to me are Access and Excel (i.e., VBA). Fortunately, I have good access to our Oracle DB, but that took some ...
-1
votes
2answers
367 views

How to explain that full automation of a spreadsheets data sources isn't a good idea?

Have an Excel spreadsheet that summarizes various key metrics for the business. The source data for these metrics comes from various sources including other spreadsheets, and web/ERP systems. A ...
3
votes
16answers
6k views

What is spreadsheet useful for? [closed]

I have been in computer business for 15 years in various roles (sysadmin, developer, researcher), and I have never encountered someone using excel for something more advanced than for formatting ...