Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • export data from gridview to excel in c# windows application

      21 results for export data from gridview to excel in c# windows application

      • All Tutorials
      • Video Tutorials
      • Quick Tutorials
      • All
      • Spreadsheet
      • Presentation
      • Writer
      • PDF

      21 results for export data from gridview to excel in c# windows application

      Use formula to set the conditional formatting

      Use formula to set the conditional formatting

      01:28

      Use formula to set the conditional formatting

      Take this table as an example. We can use the formula to set the conditional formatting by ourselves and mark the finished projects. Select the cell range A2:C22, and get into the Home tab. Click the Conditional Formatting drop-down button, and choose the New Rule option. In the pop-up dialog, we choose the Use a formula to determine which cells to format option.In the Format only cells with edit box, enter the formula "=$C2="Finished" ". The absolute reference has been added to the co....

      Spreadsheet 179 views
      Use data check method to quickly find difference items

      Use data check method to quickly find difference items

      01:40

      Use data check method to quickly find difference items

      Are you still checking table data one by one? Here are two practical methods that can help us find data difference items quickly. Take this table as an example. How can we do it, if we want to quickly find out the data difference items in the rows from Database1 to Database4? First, we select the cell range, then click the Home tab, and click the Find and Replace drop-down button. Select the Go To option under the drop-down menu, or we can also use the shortcut key Ctrl+G to open the d....

      Spreadsheet 285 views
      More features in Picture to Text

      More features in Picture to Text

      02:12

      More features in Picture to Text

      Both WPS Spreadsheets and Microsoft Excel have the function of Converting pictures to text. What are the differences between them? Microsoft Excel itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, OneNote. 1. Copy the picture and paste it into OneNote.2. Click Copy Text from Picture with the right mouse button3. Paste the text into Excel as needed. In WPS Spreadsheet, the OCR function allows us to convert pictures to....

      Spreadsheet 68 views
      Ctrl+E smart filling

      Ctrl+E smart filling

      02:50

      Ctrl+E smart filling

      After getting in touch with WPS, we know that Ctrl+C copy and Ctrl+V paste are two shortcuts, which can easily improve office efficiency. Few people know about Ctrl+E smart filling, which can intelligently identify the pattern by comparing the characters’ relationship and quickly fill cells. Next, I will introduce the usage of the smart filling shortcut key Ctrl+E. · 1. Extract charactersIn this table, we want to extract all the names in the sentences. First, enter the name that appear....

      Spreadsheet 111 views
      How to link WPS Writer and Spreadsheet together

      How to link WPS Writer and Spreadsheet together

      02:26

      How to link WPS Writer and Spreadsheet together

      In today's lesson, we will learn how to use the "Paste link" function in reality.In the workplace, we need to use Word to regularly report our work to the leader.Taking this monthly report as an example, we will generally choose to count the data in Excel and then copy and paste the data table into Word. Suppose you repeat this process every month, which will be a waste of time and sometimes leads to typographical errors. So how can we improve efficiency?The correct operation shoul....

      Writer 10 views

      How to convert Word to PDF quickly

      An editable Word document is convenient for us to revise and update, but what if we want to protect the content in that document? It would be a wise choice to convert Word documents to PDF files so that both the text and layout can be prevented from careless changes. · Steps to convert Word to PDF quickly in WPS Office.1. Open your Word document in WPS Office.2. Click Menu > Export to PDF. In the Export to PDF dialog:3. Check the document that you need to convert to PDF.4. Input the Ex....

      Writer 165 views

      How to compare two sets of data in WPS Office Excel

      In this article, you will know how to compare two sets of data in WPS Office Excel with simple steps as following: In our daily work, we often need to compare two sets of data, but it makes us dizzy to switch back and forth. So how can we compare two sets of data quickly and easily? Let's have a try step by step. Here we take a performance appraisal table of employees as an example. We want to know how they performed and whether they made progress in these two months. We can use th....

      Spreadsheet 576 views

      How to insert PDF in Word documents on Mac or Windows

      When it comes to inserting multiple PDF files into a page in word documents, it is a good choice to place a PDF file as an image into word documents in Microsoft Office or WPS Office Writer. If you want to place a PDF file as an image into word documents, where you can easily crop, resize, or duplicate. Today, this article will introduce you to how to insert PDFs in word documents in WPS Office Writer. l How to convert .doc files to .pdf files?1. Head to the Tools tab and click the Exp....

      Writer 131 views
      Prev 123 Next
      WPS Academy