Microsoft Developer Network > 포럼 홈 > SharePoint - Excel Services > Is it possible to use ExcelServices webservice to format cells?
질문하기질문하기
 

답변됨Is it possible to use ExcelServices webservice to format cells?

  • 2009년 6월 29일 월요일 오후 8:15mooserz 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     
    Is it possible to use the ExcelServices web service to format a cell or a range??? Modifying the data works great now, but I'm not seeing much on working out colors, borders, etc.
    • 편집됨Mike Walsh MVPMVP, 중재자2009년 6월 30일 화요일 오전 6:41Excel Servicesa added to Title and it was slightly re-written to make it into a question
    •  

답변

  • 2009년 7월 7일 화요일 오후 10:49Shahar Prish - MSFT 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     답변됨
    There is no direct way of doing that.

    That said, you can use conditional formatting based on another cell to do this - it will be quite annoying and will not be realistic for complex formatting, but there you have it.
    Shahar Prish Blog: http://blogs.msdn.com/CumGranoSalis Professional Excel Services: http://www.amazon.com/Professional-Excel-Services-Programmer/dp/0470104864

모든 응답

  • 2009년 7월 3일 금요일 오전 8:53Serge Luca [MVP]MVP사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     
    I don't see any way to do this withe the Excel Services API, but you can modify the spreadsheet by using the OpenXml sdk 2.0   and re-publish it


    Serge Luca; blog: http://www.redwood.be
  • 2009년 7월 7일 화요일 오후 10:49Shahar Prish - MSFT 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     답변됨
    There is no direct way of doing that.

    That said, you can use conditional formatting based on another cell to do this - it will be quite annoying and will not be realistic for complex formatting, but there you have it.
    Shahar Prish Blog: http://blogs.msdn.com/CumGranoSalis Professional Excel Services: http://www.amazon.com/Professional-Excel-Services-Programmer/dp/0470104864