Skip to main content
Solved

How to read specific sheet with PX.Data.XLSXReader

  • September 2, 2022
  • 3 replies
  • 101 views
  • Translate All
priekenberg40
Varsity I
Forum|alt.badge.img+1

How do i have to use PX.Data.XLSXReader to read a specific sheet of the XLSX-File?

Best answer by priekenberg40

Solved by using OpenXML

View original

      3 replies

      priekenberg40
      Varsity I
      Forum|alt.badge.img+1

      Solved by using OpenXML

      Translate
        Chris Hackett
        Community Manager
        Forum|alt.badge.img
        • Chris Hackett
        • Acumatica Community Manager
        • March 15, 2023

        Thank you for sharing your solution with the community @priekenberg40 !

        Translate
        Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
          Freshman II

          // Switch to the desired sheet by name:

           // Switch to the desired sheet by name
              reader.Worksheets.Set("SheetName");

           

          Translate
            Terms & ConditionsAccessibility statement
            About Acumatica ERP system
            Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
            © 2008 — 2024  Acumatica, Inc. All rights reserved