W
W
WebForYou2020-03-01 13:40:18
Parsing
WebForYou, 2020-03-01 13:40:18

Choosing a solution for parsing a large Excel file?

It is necessary to automate the following task:
The program receives an xlsx file as input. There are several sheets in the file (sheets for settlements), each sheet contains addresses of subscribers (column).
It is necessary to determine the technical feasibility of a certain service by address. Ie, find the subscriber in the database at the address and determine the technical possibility. The company uses oracle subd.
You need to implement this task as a web application.
Although one file is input, this file is > 50 Mb. It opens for about a minute. The number of addresses on 1 sheet can reach 1 million records.
As I understand it, you need to choose something quick (C? C sharp? Is the node suitable or python?)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dimonchik, 2020-03-01
@dimonchik2013

Python is suitable
with one file, it’s generally simple, even put it in Googlesheet (xs what’s with the line lam) and work easily

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question