Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [excel]

The tag has no usage guidance.

1
vote
1answer
41 views

Bulk Inserting Data with Duplicates or Line by Line Insertion Without

I am loading a large amount of data (2,000 files with about 30,000 rows, 30 columns) for use in a Django application. The files are based on 40 different templates. The column names are consistent ...
0
votes
2answers
115 views

Passing csv files between regions

I have a desktop app that generates numerous csv files. The application always runs on PCs that have been configured for the English (United Kingdom) region/format, but it's feasible that files might ...
-2
votes
1answer
44 views

Strategy for VLOOKUP in VBA

I need to fill a Products table in file A with their manufacturing costs that are in another Costs table in file B. Currently, I read Products and Costs tables into their respective arrays and for ...
1
vote
1answer
46 views

Installing mixed technology desktop application

What are the options for installing an application which uses batch files, python, excel and proprietary software? I developed a command line shell to run fast, repeatable traffic simulations largely ...
0
votes
2answers
194 views

Is there a problem when data and logic are not separated?

You can do a lot with Excel. Even without Visual Basic Script. But the data and the logic is in one file, whereas normal programming languages usually have another file (or a database) for the data. ...
1
vote
1answer
2k views

Best Practices for Automating Word Documents [closed]

I recently started at a company as a Automation Developer. My job is to automate periodic reports (in Word) for all of our customers (~50), one for each. Each report is slightly different, so I am ...
2
votes
2answers
10k views

Data structure to hold Excel column names with their values

I am learning how to read Excel workbooks in Java and want to know what a good Data Structure will be for holding Column names with the values under them. Example: I want to be able to call a method:...
3
votes
2answers
993 views

Reverse Engineering a Spreadsheet into a Model and Controller

I need some help with the approach to a specific project. We have a large excel workbook with a ton of worksheets. There are many user inputs, which formula fields pull, return, repeat. This all ends ...
-7
votes
1answer
1k views

OPENPYXL tutorial / help with AVERAGE DICTIONARY

For my thesis I am trying to extract some data from Excel. I want to create a list with the name as in excel and then append the values to said list so I can work with it. EDIT I realize I ...
0
votes
0answers
338 views

Generating dual .xlsx files and .htm pages of the same data

Here are my requirements: Generate Excel reports for users, attaching them to emails Additionally, insert hyperlinks into those emails where the user can view the same report on a web page. I have a ...
8
votes
2answers
358 views

Is it OK to have a property of type COM object

I am developing a COM addin for Microsoft Excel, using VB.Net. I wrote a class to represent a worksheet that contains certain elements. Let's say for example it has a ListObject. I create a property ...
2
votes
2answers
1k views

Managing sets of configuration data for an Excel/VBA program

I have two versions of an "Excel-Tool", i.e. a spreadsheet with a lot of vba code. Lets say, this tool is used to monitor two facilities. Both facilities differ in minor aspects. That means, I have ...
1
vote
1answer
1k views

Excel worksheet population and fomatting is slow

I have written a VSTO plugin in C# which populates several worksheets. During the population process cell values or formula are added one at a time according to user-definable criteria taken from a ...
1
vote
1answer
578 views

Range or Row and Column Indices in VBA

I would like to know what the pros and cons are for storing a range variable instead of four integers or long variables (representing the first and last row and column) to define that range. One ...
20
votes
7answers
10k views

Team member questioning moving from VBA to C#

Background Last year, I was asked to create a tool to be used for business planning for around 10 users. This was done on behalf of another IT team who "sub-contracted" the work to me, and due to the ...
1
vote
1answer
513 views

Should I use Strategy Pattern for this task?

I'm setting up a data validator that will iterate through the rows of a spreadsheet, and for each column, perform a validation check. I was thinking that this might be an appropriate task for the ...
1
vote
0answers
4k views

Excel: Vba Copy and paste efficiency with 000's of rows and columns

I'm sure this is probably out there but I can't seem to find it. Updates I have tested some different code, and reduced my time to complete the task from 50/60 seconds to 10 seconds. This is what I ...
-1
votes
1answer
721 views

Asp.net Web Form for Local Use [closed]

I am trying to build an Asp.Net Web Form project to use at my job. We work with a lot of excel files and a large task for me and others at my company is combining/comparing/updating data in these ...
0
votes
1answer
117 views

Reflection performance in this iteration of a (probably) large excel file

I'm wondering the performance of reflection in this situation. I'm iterating a (probably) large excel file (let's say 3000 max) which it's going to be done from time to time, and the implementation ...
12
votes
3answers
3k views

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

See my Update at the bottom for more. 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 ...
3
votes
3answers
3k 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
138 views

Which file format should I use as an alternative to my current Excel worksheet? [closed]

My .NET application does its work and then creates a report (an Excel worksheet). That report contains thousands of short text strings [KEY - VALUE]. So Excel worksheets suites very well, one column ...
0
votes
1answer
703 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 ...
1
vote
4answers
308 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 ...
0
votes
1answer
113 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
26k 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 ...
2
votes
1answer
787 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. ...
1
vote
1answer
3k 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 ...
6
votes
0answers
673 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 ...
12
votes
5answers
1k views

What methods are available to show colleagues the advantages of a database+application solution over Excel?

I work in a company where there are Excel spreadsheets everywhere. As my colleagues are non-programmers, I'm sure they haven't contemplated that there might be a better/easier/more productive way of ...
16
votes
4answers
4k 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 ...
1
vote
4answers
825 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 ...
9
votes
2answers
2k 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 http://docs....
3
votes
1answer
2k 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 ...
-2
votes
3answers
9k 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 ...
-1
votes
3answers
312 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 ...
0
votes
3answers
4k views

Parsing excel data in Java before saving it to database [closed]

I'm working on some project where I have to make a database to store 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 ...
2
votes
2answers
172 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 ...
2
votes
4answers
5k 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 data,...
9
votes
6answers
595 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 ...
5
votes
1answer
678 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 ...
2
votes
4answers
8k 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 ...
-1
votes
2answers
444 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
17k 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 ...