将sharepint列表转换为pdf和excel文档？ [英] Conversion of sharepint list to pdf and excel document ?

问题描述

您好我是sharepoint 2010的新手，



我需要帮助转换 sharepoint list to pdf 和 sharepoint list要excel 喜欢将报告作为文件。



一旦提交了pdf按钮，你可以帮我编写代码，比如创建列表的pdf。



先谢谢

Hi I am new to sharepoint 2010,

I need to help in conversion sharepoint list to pdf and sharepoint list to excel like to make report as documents.

Can you help me out in coding like create the pdf of list once the pdf button is submitted.

Thanks in Advance

推荐答案

<script type="text/javascript" src="https://workspace.wp.siemens.com/sites/LTIDev/LTI/SiteAssets/JS/jquery-2.2.1.min.js"></script>
<input type='button' value='Get Item IDs' onclick="clickMethod();"/>

<br />

<script language="javascript" type="text/javascript">
var itemStatus ;
function clickMethod() {
    var ctx = SP.ClientContext.get_current();
    var items = SP.ListOperation.Selection.getSelectedItems(ctx);
    var myItems = '';
    var i;
    for (i in items) {
        myItems = items[i].id;
    }
    //Fetching selected item based on ID
    RetrieveListItem(myItems)

}// End of Click method


function RetrieveListItem(itemids)
    {

    var _ctx = new SP.ClientContext.get_current();
    var _List = _ctx.get_web().get_lists().getByTitle("LTI Ticket Incident"); // Enter List name
    var _camlQuery = new SP.CamlQuery();
    _camlQuery.set_viewXml("'<View><Query><Where><Eq><FieldRef Name=\'ID\'/><Value Type=\'Number\'>"+itemids+"</Value></Eq></Where></Query></View>'");
    this._ItemColl = _List.getItems(_camlQuery);
    _ctx.load(_ItemColl);
    _ctx.executeQueryAsync
    (
    Function.createDelegate(this, this.onRetrieveQuerySuccess),
    Function.createDelegate(this, this.onRetrieveQueryFailed)
    );
    }

    function onRetrieveQuerySuccess(sender, args)
    {
        var _ListItemEnumerator = _ItemColl.getEnumerator();
        while (_ListItemEnumerator.moveNext())
        {
        var _ListItem = _ListItemEnumerator.get_current();
        var updateitemid = _ListItem.get_id(); // Saving item ID to variable
        itemStatus = _ListItem.get_item('Status') // Update column
            // Validating column
            if (itemStatus == 'Assigned')
            {

                    var _ctx1 = new SP.ClientContext.get_current();
                    var _List1 = _ctx1.get_web().get_lists().getByTitle("LTI Ticket Incident"); // Enter List name
                    this._ListItem1 = _List1.getItemById(updateitemid);
                    _ListItem1.set_item('Status', 'Pending'); // Pass column and value to update column
                    _ListItem1.update();// updateing item to list

                    _ctx1.load(_ListItem1);
                    _ctx1.executeQueryAsync
                    (
                    Function.createDelegate(this, this.onUpdatedQuerySuccess),
                    Function.createDelegate(this, this.onUpdatedQueryFailed)
                    );

            }
            else
            {alert("Not assigned")}

            }
        //alert(_ListItemInfo.toString());
    }

    function onRetrieveQueryFailed(sender, args)
    {
    alert('Request failed. ' + args.get_message() +'\n' + args.get_stackTrace());
    }
       function onUpdatedQuerySuccess()
        {
        alert('Item status updated'); // Update column successful
        }

        function onUpdatedQueryFailed(sender, args)
        {
        alert('Request failed. ' + args.get_message() +'\n' + args.get_stackTrace());
        }
</script>

这篇关于将sharepint列表转换为pdf和excel文档？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！