Questions tagged [excel]
The excel tag has no summary.
61 questions
2
votes
2
answers
1k
views
How can I manage validation logic for 150+ screens with unique business rules across microservices?
Currently, I'm working on an application with a microservice architecture. Each screen may corresponds to a separate microservice, and each screen has its own unique validation logic. Some screens ...
1
vote
1
answer
199
views
Architecture for a system where users want to use Excel for collecting and merging data
My organization handles batches of stuff that need to be checked by Quality Control. What I need is something for the people who work in Quality Control to be able to register and input data inside ...
-1
votes
1
answer
110
views
General Excel Processor and Validator
I've been working on this project where my responsibilities are to code for validating, processing and then dumping into database excel file.
Me and my colleague tried multiple approaches to make it ...
0
votes
0
answers
141
views
Securely Handling Session Keys in Excel for API Authentication
I'm working on an Excel tool that needs to synchronize with a CRM via its API. The CRM's API authentication process involves logging in with a username and password, after which a session key is ...
1
vote
1
answer
109
views
How best to keep Excel Workbook field in sync across class instances
I know almost nothing about threads, synchronization, ...
That being said, I am working on a record handler, that hits Excel sheet to pull/push data. There exist, in my code base, a BaseRecordHandler, ...
26
votes
6
answers
9k
views
How can I access Excel from my backend?
We have a lot of business logic in Excel files and we would like them to integrate in a web application (a Node.js web application). We don't want to rebuild the logic in a programming language. ...
4
votes
3
answers
2k
views
Requirements engineering done in Excel and Word?
Throughout this semester my classmates and I had to do the pre-coding(?) phase of a project (requirements and such) as part of our Software Engineering course. The way our professor had us do it seems ...
0
votes
0
answers
2k
views
Is it possible to run an Excel macro-powered file on a server?
I've an Excel file (offline, on my computer) that elaborates medium-large amount of data using VBA Macros. Basically, this Excel macro-powered file works with a person that adds the data to an Excel ...
-1
votes
2
answers
419
views
Excel/VBA to Application
In an engineering company, there are many engineers that edit in Excel/VBA Spreadsheets to perform some engineering calculations.They all do more or less similar things: calculate, manage engineering ...
2
votes
1
answer
849
views
Easiest way to build and distribute Excel UDF add-in capable of Statistical Analysis
01 - BACKGROUND:
I'm a typical non-programmer R user for 6+ years. Which means:
i) I`m comfortable with the language most of the time and have written R packages for myself, but
ii) writing C++ code (...
0
votes
1
answer
51
views
Inserting dissimilar excel files in SQLdatabase
I have a bunch of excel files(Multiple sheets) with some data of similar types, but i'm having troubles when this data has to be inserted in SQL DB. the data in these files are unordered (eg: the ...
-2
votes
1
answer
695
views
Export huge excel file
I develop a web application in Angular (frontend) and Scala (backend) for a big data team. Because they use large files for export/import, I build a module which is a copy of Microsoft Excel.
So, what ...
3
votes
2
answers
949
views
Is Excel data model as good as or better than Microsoft Access?
I'm working with several Excel worksheets and workbooks that need to consolidated or linked to each other. These workbooks will track client interactions for different team members.
I did the initial ...
4
votes
3
answers
488
views
Possible alternatives to excel as business logic implementation
I just started my internship as a computer science student. The project I'm working on is web based price calculation. Previously, the price calculation have been done in a quite huge excel ...
1
vote
2
answers
1k
views
Excel Addin VBA, Backend/Frontend
I have a question regarding what is supposed to be backend and frontend for desktop applications and in this special case, an Excel Addin VBA.
My application contains lot of forms and modules. I ...