Posts

Showing posts from April, 2015

Convert Part of Excel to Image Using Free Excel API

Image
on Convert Part of Excel to Image Using Free Excel API Convert Part of Excel to Image Using Free Excel API In MS Excel, it is pretty easy to export Excel range as image with following steps: Select a section that you need to export as image. Click Home>Copy>Copy as Picture, then picture will be save in clipboard. Paste the copied picture to your Paint tool, then save the picture to the specified folder in specified format. However, in this post, I’ll introduce how to convert section(s) to image programmatically using Free Spire.XLS  in C#. As a matter of fact,  Spire.XLS  has provide a  Worksheet.SaveToImage(int firstRow, int firstColumn, int lastRow, int lastColumn)  method for programmers to save selected range of cells to image easily, now let’s check the detailed steps as below. Main steps: Step 1: Create a new Excel document and load the test file. Step 2: Get the first sheet from the workbook. Step 3: Save specific cells range to image via Worksheet.Sav

How to find real error in Sharepoint using Correlation ID

Image
For viewing error information in sharepoint some times we get only Correlation ID for the error. So in my previous article  Log files  we have to choose any one log file. If you get error in SharePoint 2010 most of them are generic like this one, where only thing we can see is Correlation ID. Here am choosing  this one.  SharePoint LogViewer by Overroot Inc –  http://sharepointlogviewer.codeplex.com . we have to download it and click the play button. so our application log details will be displayed here.in filter opetion we have to choose correlation option and then we have to enter our correlatin id and click search button. it will display the result which is  belongs to the error.

Edit user Details or Email in sharepoint site

Image
Sometimes AD synchronization stales between domain controller and SharePoint server. This are the steps to solve this issue 1. Go to SharePoint central administration 2. Select manage service applications 3. Manage user profile 4. Find user profile 5. Edit user profile work email field 6. Go to Job definitions on Check Job Status 7. Select Job Definitions 8. Scroll down and select User Profile Service Application – User Profile to SharePoint Full Synchronization 9. Wait for the job to finish running and check if you can set Alerts for that specific user.

SharePoint displays 'System Account' as the logged in user

Sometimes SharePoint administrators would like to update content in their site in certain ways, but don't want everything to show up as being last modified by them by name. Instead, they would prefer that the record simply show that it was last updated by  System Account . On the other hand, sometimes administrators are not sure why SharePoint shows them as being logged in as System Account and why everything they edit or upload is tagged as such. The Problem It is not immediately clear in SharePoint when the user will be shown as System Account. The options to control this are also not immediately obvious. At times the problem is even rooted in what account is being used to run the application pool for a web application. If the identity of the application pool is that of a particular administrator or if the administrator logs in as the farm account or the application pool account, then SharePoint will show that person as System Account. If none of these three is the case t

Using jqGrid in ASP.NET or SharePoint

In this post, I will show how to use a jqGrid (This approach will work in an ASP.NET application or a SharePoint site). I will try to cover as many properties of jqGrid as I can. To start off, I added references to the following files on my *.aspx page. 1. jquery-ui-1.8.18.custom.css 2. ui.jqgrid.css 3. jquery-1.7.1.min.js 4. jquery-ui-1.8.18.custom.min.js 5. grid.locale-en.js 6. jquery.jqGrid.min.js 7. json2.js Files 1, 4 and the corresponding images files can be downloaded from the jQuery UI ThemeRoller site. And files  2, 5, 6 can be downloaded from the jqGrid site‘s download page(although I recommend downloading these files from a site that has a working example of jqGrid. The reason I suggest this method is, when I tried downloading these files from the jqGrid’s website by selecting the required modules, things worked fine for me initially, but later I reached a point where the jqGrid was not working for me, though there was no problem in my code. Then I replaced the jq

CAML Query syntax and options in SharePoint

As Small syntax error or order of tag in spquery can result any web part (or any thing in which spquery is used) doesn’t work, I’m explaining SPQuery with example, hope which may help you. CAML (Collaborative Application Markup Language) SPQuery  is the SharePoint object which is used to perform a query operation against SharePoint data. SPList.getItems(SPQuery)  is the step, will return SPListItemCollection  which satisfies the query.SPQuery has one data member ‘ Query’ , which need to set before passing SPQuery object to  SPList . Some Properties Properties Description RowLimit Gets or sets a limit for the number of items returned in the query per page. <RowLimit>10</RowLimit> --- Can be used as: query.rowLimit = 10; ViewFields Gets or sets the fields that are displayed in the query. <ViewFields>         <FieldRef Name='Title'/>         <FieldRef Name='Name'/> </ViewFields> --- Can be used as: SP