Welcome to OpenXML Developer Sign in | Join | Help

Changing Excel value inside pptx sheet

Last post 08-06-2008, 5:18 PM by eitanal. 2 replies.
Sort Posts: Previous Next
  •  08-06-2008, 10:15 AM 3537

    Changing Excel value inside pptx sheet

    Hi,

    I have small pice of Excel inside my Presentation.
    I would like to change some values inside it, I saw that the values located inside the BIN file,
    in the Embedded folder.
    My questions are:
    How do I get to this file (what releation and from which XML file), and how can I read from it, without the full path.
    I was trying to use StreamReader, but it must get the full path of the file.

    Appreciate any help

    Eitan

  •  08-06-2008, 10:48 AM 3538 in reply to 3537

    Re: Changing Excel value inside pptx sheet

    Hi,

    I tried to go that way, or just try to add a new excel file, but at the end I decided to use just normal pptx table features, like <a:tbl> ...

    But if you want to find out where and get the binary of the excel file, you can use package explorer to find the uri inside the pptx package and then you can write the code to get the part using that uri.

    It should be something like /ppt/embeddings/Microsoft_Office_Excel_97-2003_Worksheet1.xls

    Paulo.






  •  08-06-2008, 5:18 PM 3540 in reply to 3538

    Re: Changing Excel value inside pptx sheet

    Hi,

    I opened the package using Winzip, I reached the BIN file, and open it using notepad.
    Inside I saw my values.
    To open the file using C#, I used the I.O, like StreamReader, but the StreamReader needs a direct path to the file, and when we open the package (using C# code), there is no direct path for any of files.

    Is there any way to open the BIN file, on the fly, using the C# code?

View as RSS news feed in XML