| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 |
| An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error. |
다음은 HTML 코드입니다.
<form action="/SaveToExcel.php" method="post" target="_blank"
onsubmit='$("#dataToDisplay").val( $("<div>").append( $("#ReportTable").eq(0).clone() ).html() )'>
<pre><input type="image" src="/images/icons/save_excel.png"></pre>
<pre><input type="hidden" id="dataToDisplay" name="dataToDisplay" />
</form>
설명
reportTable - 저장하기 원하는 테이블 ID
dataToDisplay - 서버로 POST될 베이블을 위한 hidden변수
폼의 onSubmit시에 저장할 HTML 테이블을 jQuery 메서드로 쉽게 처리할수 있다.
<table>을 포함한 HTML코드를 가져오는 부분의 처리가 중요하다.
jQuery.html() 메서드는 innerHTML만 가져오므로 table id를 기준으로 실행하면 <table> 태그가 빠지게 된다.
그래서 <div> 안에 전체 <table> 을 append하면 <div> <table>...</table> </div> 가 되고
여기서 .html() 을 실행하면 <table>...</table> 을 리턴하므로 원하는 결과를 얻을 수 있다.
One of our most senior developers on Excel Services, Shahar Prish, is busy writing posts in his blog on the new programmability features in the 2010 version of Excel Services. The first set of posts talk about REST and moving forward he will expand to the new JavaScript OM we added this release. Here are the links, if you care at all about building custom solutions for Excel and Excel Services they are a great read:
General posts about REST:
Welcome to the new Excel Services
So what does REST on Excel Services look like???
Discovery via the Excel Services REST APIs
Getting ranges via Excel Services REST as well as Charts and Discovery
Excel Services REST APIs – the basics
Advanced Excel Services REST API capabilities – passing parameters to a spreadsheet
How to seamlessly embed data from Excel Services spreadsheets into Word
The Excel Services Windows Gadget:
Introducing the Excel Services Windows 7 Gadget
Showing Excel ranges in the Excel Services Gadget
Bringing it all back home – using advanced REST functionality with the Excel Services Gadget
And the blog is starting to show how to actually code the gadget:
Coding the Excel Services Windows 7 Gadget – Part 1 - Settings
