nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Siemens Community Catalyst Program

The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.

Nominate Now

Legacy and Modern Excel connectors

Clara

Hello,

can anyone explain the difference between the Legacy and Modern Excel connectors? I searched for documentation but can't find any so far.

------------------------------
Clara
Business Analyst
IL
------------------------------

Find more posts tagged with

English

Monarch

Accepted answers

Ermela

Hi Clara,

The short answer to your question is that Legacy Excel connector uses OLEDB to open Excel files while Modern uses Aspose engine. The main difference between these two engines is performance and memory usage when working with large Excel files. The Modern engine uses less memory and performs better than the Legacy engine. Also, the Modern engine can open Excel files with more than 255 columns.

HTH

------------------------------
Mela Sarenas
Manager, QA
Altair formely Datawatch
------------------------------
-------------------------------------------
Original Message:
Sent: 03-20-2019 10:04 AM
From: Clara Bonaccorsi
Subject: Legacy and Modern Excel connectors

Hello,

can anyone explain the difference between the Legacy and Modern Excel connectors? I searched for documentation but can't find any so far.

------------------------------
Clara
Business Analyst
IL
------------------------------
"

All comments

Ermela

Clara

Hi Clara,

The short answer to your question is that Legacy Excel connector uses OLEDB to open Excel files while Modern uses Aspose engine. The main difference between these two engines is performance and memory usage when working with large Excel files. The Modern engine uses less memory and performs better than the Legacy engine. Also, the Modern engine can open Excel files with more than 255 columns.

HTH

------------------------------
Mela Sarenas
Manager, QA
Altair formely Datawatch
------------------------------
-------------------------------------------
Original Message:
Sent: 03-20-2019 10:04 AM
From: Clara Bonaccorsi
Subject: Legacy and Modern Excel connectors

Hello,

can anyone explain the difference between the Legacy and Modern Excel connectors? I searched for documentation but can't find any so far.

------------------------------
Clara
Business Analyst
IL
------------------------------
"

That's great! If possible I would like to hear about some of the other differences. So far I've found the modern version may not behave the same way as the legacy version in terms of applying formats to sources and exports as well. Am I correct about this? I say this in a hopeful manner, I like what I'm seeing.

------Original Message------

Hi Clara,

The short answer to your question is that Legacy Excel connector uses OLEDB to open Excel files while Modern uses Aspose engine. The main difference between these two engines is performance and memory usage when working with large Excel files. The Modern engine uses less memory and performs better than the Legacy engine. Also, the Modern engine can open Excel files with more than 255 columns.

HTH

------------------------------
Mela Sarenas
Manager, QA
Altair formely Datawatch
------------------------------
"

Ermela

That's great! If possible I would like to hear about some of the other differences. So far I've found the modern version may not behave the same way as the legacy version in terms of applying formats to sources and exports as well. Am I correct about this? I say this in a hopeful manner, I like what I'm seeing.

------Original Message------

Hi Clara,

The short answer to your question is that Legacy Excel connector uses OLEDB to open Excel files while Modern uses Aspose engine. The main difference between these two engines is performance and memory usage when working with large Excel files. The Modern engine uses less memory and performs better than the Legacy engine. Also, the Modern engine can open Excel files with more than 255 columns.

HTH

------------------------------
Mela Sarenas
Manager, QA
Altair formely Datawatch
------------------------------
"

Oh the Modern and Legacy Excel engines are for bringing in Excel files. In addition to performance and bringing in 255 columns using the Modern engine, older versions of Excel (Excel 95 .xls) can only be opened using Legacy. Modern engine supports Excel .xls if it is in 97-2003 workbook format.

As for applying formats and exporting, the Excel engines does not apply. If you see problems in formatting and exporting to Excel, we would like to know it.

Thanks.

------------------------------
Mela Sarenas
Software Quality Manager
Datawatch Corporation
Bedford MA
+ 1.800.445.3311
------------------------------
-------------------------------------------
Original Message:
Sent: 03-21-2019 10:56 AM
From: Clara Bonaccorsi
Subject: Legacy and Modern Excel connectors

Original Message------

Hi Clara,

The short answer to your question is that Legacy Excel connector uses OLEDB to open Excel files while Modern uses Aspose engine. The main difference between these two engines is performance and memory usage when working with large Excel files. The Modern engine uses less memory and performs better than the Legacy engine. Also, the Modern engine can open Excel files with more than 255 columns.

HTH

------------------------------
Mela Sarenas
Manager, QA
Altair formely Datawatch
------------------------------
"

Al_22614

Hello:

Is Modern also best used with large .csv files?

Thanks in advance for reply.

Quick Links

Upcoming Events

Comparing PWM control strategies - Impact on E-Motor performance
Join us for a community conversation on Pulse Width Modulation (PWM), a fundamental technique in electric motor control, and explore how different PWM strategies can yield significantly different results. This webinar provides a comparative analysis of various PWM methods and their effects on motor efficiency, torque…
Advanced Iterative Solver (AIS) for large models in Simcenter Feko
Join us for a community conversation to discover the Advanced Iterative Solver(AIS) in Simcenter Feko and its application to electrically large and computationally demanding electromagnetic models. The session will provide a general overview of how iterative solution methods can help improve efficiency of large scale…
Advancing power electronics design with Simcenter PSIM and High-Performance Computing
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…

View all community events