Developer Tutorials, Beginner & Advanced, Programming Guides and Tips

One of the oldest of the Microsoft Office applications - Excel is already packed with a rich set of features. As a developer many times we have to work with excel files like creating/modifying etc. Programming with Excel can be a crucial solution with data-rich projects/applications. ByteScout Spreadsheet SDK provides many features that let the developer create rich Microsoft Excel solutions with the use of its easy and extensive SDKs. In this article, we are [...]

Read and Write Excel files in C# tutorial shows how to write to and read from Excel file from your application using Speadsheet SDK. Use sample C# source codes for Excel reading and writing. Get the most of this tutorial by learning the source samples. Read the Excel file in C# with the help of the code below. Write to Excel file from your application How to read excel file in C# console application:   Microsoft [...]

Analytic Hierarchy Process (AHP) was initially developed by Thomas L. Saaty in the 1970s and is used as a method to organize and analyze complex information for the purpose of decision making based on multiple parameters. Types of scales Nominal - no information on the preference of objects carries, except for equivalence of objects, an example of a scale is gender, marital status. Ordinal - used to arrange objects in the order of their preference, [...]

In the field of data mining, the trickiest part is to automate the software to read tables. In normal extraction, it's just paragraph or image, but when tables are involved one needs to be sure that they can relate data from rows to their respective columns. And complexity raises when the table is spanned across multiple pages. ByteScout PDF Extractor SDK or PDF.co Web API is one of the best solutions available in the market [...]

Processing is a programming environment for developing visual applications, works of art, and animations. Developed since 2001, designed by Casey Reas and Ben Fry, Processing has expanded out of MIT into a Foundation popular with thousands of (current and prospective) designers and artists in multiple disciplines. As Reas and Fry say ‘“Processing” can be somewhat ambiguous’. For the purposes of this tutorial Processing with reference to the things, we create in the standalone Processing program. [...]

One of the known problems in data extensive business is to extract data from PDF when PDF is the output of the scanned document. In this article, we'll see how to extract text from scanned pdf using one of ByteScout PDF SDK. ByteScout is an established player known to provide reliable PDF solutions to developers. We'll see through how to convert scanned pdf to text using ByteScout PDF Extractor library. For this program purpose, I [...]

SQL is a server-side scripting language used to query relational databases such as MySQL database. Relational databases as the name referrers are ways in which data is stored in formatted clusters such as databases and their corresponding SQL server tables in ways and means which creates relationships between tables of similar or even different databases. The language is used to manipulate data stored on the server by creating and deleting tables, creating and dropping databases, [...]

Laravel is a great low-code platform or framework for PHP coding! Laravel creates a lot of code automatically and includes a bevy of convenient templates to speed up development. Laravel also supports the model-view-controller (MVC) coding paradigm for PHP programming. In this ByteScout advanced developer intro, we will survey the awesome features of Laravel with example code. Developers describe Laravel as a PHP platform for coding web apps. But we want to include it as [...]

Lambda expressions in Python In lambda programming, a definition of a function not determined by any object is called the lambda expression or the anonymous function. Based on the mathematical basics of lambda calculus, lambda functional programming introduces several fundamental principles: Higher-Order Functions Unchanged data Clean features In this C# and Python lambda tutorial, we will clarify each of these concepts separately. In functional languages, the function is the basic building block of your code. [...]

Fascinating commercial applications of the functional programming paradigm abound today. Why do we hear so little about them? For one thing, functional programming (FP) is not the most common paradigm, and most developers are not intimately familiar with its nuances and applications. We’re going to change that course with a foray into practical FP today! FP compilers enforce many rules which are foreign to most OOP imperative developers today. The use of recursion instead of [...]