Cообщество разработчиков на платформе Microsoft >
Форумы
>
SharePoint - Excel Services
>
Is it possible to use ExcelServices webservice to format cells?
Is it possible to use ExcelServices webservice to format cells?
- 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, Модератор30 июня 2009 г. 6:41Excel Servicesa added to Title and it was slightly re-written to make it into a question
Ответы
- 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- Помечено в качестве ответаXue-Mei Chang-MSFTMSFT, Модератор9 июля 2009 г. 8:52
Все ответы
- 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 - 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- Помечено в качестве ответаXue-Mei Chang-MSFTMSFT, Модератор9 июля 2009 г. 8:52
