Interop.Excel : no contents in the worksheet RRS feed

  • Question

  • Hello everybody,

    A big problem appears to use the american Microsoft forums : they are all archived, letting think that posting a question in it is no more possible.

    Usually, the problem I met with Microsoft forums in French is that we are about a dozen persons any more to read them. Happily, sometimes one of the twelve knows the answer. Is there any possibility that it is not worse in America ?

    It would be fine, I could open an Excel workbook (with extension xlsx) from Visual Studio with Interop, but it seems the only thing I am able to read in the worksheet is its name. Cells.Count = 0, where I wrote nine cells and Excel UI (2013) is able to show them. I wonder whether I must precise a format in the open instruction, but the documentation I find online does not help a lot about this. Sorry to have forgotten the details after a few years.

    So, please if somebody can help, otherwise it seems to require high motivation to use Microsoft technology.

    • Edited by Gloops Monday, November 18, 2019 11:04 AM
    Monday, November 18, 2019 11:00 AM


All replies