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

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…
Getting Started with Faster Motor Building in Simcenter Simlab
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Practical hybrid solver workflows in Simcenter Feko
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…

View all community events