C# Corner

Resources  
  • Xamarin.Forms - Camera AppNov 22, 2017. In this we will learn how to create your own camera application and showing the last captured image.
  • How To Track Facebook Wall Messages In An Excel Table Using Microsoft FlowNov 22, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one and do something with the data from that event into another service. It makes it practical and simple for line-of-business. The users can build workflows that automatically do some business tasks and processes across applications and services.
  • SharePoint 2016/2013/Online - How To Apply Password Encryption For Component As Service Using PowerShellNov 22, 2017. In this article, I will discuss the mechanism to authenticate the requests to SharePoint Lists while working with PowerShell.
  • Generating Your First Components And Modules In Angular 5 AppNov 21, 2017. This post is a continuation of the course Developing an Angular 5 App series
  • Xamarin.Android - QR Code Reader AppNov 21, 2017. In this article, I shall show you how to make a QR code reader app in Xamarin.Android.
  • Make A Text Recognition App Using Xamarin.AndroidNov 20, 2017. Today, I shall show you how to create a Text Recognition app using Xamarin Android. I shall used Xamarin Google-Play-Services Vision for text recognition.
  • Angular 5 Basic Demo Project OverviewNov 20, 2017. This post is a continuation of the Angular 5 series
  • How to Return Files From Web APINov 18, 2017. This article explains how to transfer/ return files(PDF/Doc/Excel/zip) files from Web API service
  • ParallaxView Control In UWPNov 18, 2017. Reading this article, you can learn how to use ParallaxView Control in Universal Windows Apps development with XAML and Visual C#.
  • Radial Progress Bar Control In UWPNov 17, 2017. Reading this article, you can learn how to use Radial Progress Bar Control in Universal Windows Apps development with XAML and Visual C#.
  • Create App Using Xamarin.Android Using C# - Part FourNov 17, 2017. Xamarin.Android has native user interface controls. These controls can be easily added to Xamarin.Android apps using the Android Designer or programatically via XML layout files. Xamarin.Android exposes all of the user interface object properties and methods in C#.
  • Build Intelligent Apps with Microsoft Data PlatformNov 16, 2017. Learn how to build intelligent apps using Microsoft data platform and tools.
  • ScrollHeader Control In UWPNov 16, 2017. Reading this article, you will learn how to use ScrollHeader Control in Universal Windows Apps development with XAML and Visual C#.
  • Deploy ASP.NET MVC Web Application Using Azure Cloud ServiceNov 16, 2017. Cloud service comes under the PaaS service model, as with a web app service we can deploy our web application in this service and moreover it provides more control on the VMs for the users and we can install our own software by remoting it.
  • Passing Parameters To Middleware In ASP.NET Core 2.0Nov 15, 2017. I discussed in an earlier post that it is good practice to define middleware in a separate class and add to the pipeline using extension methods. We may also need to pass information to our middleware classes though and I’ve come across two patterns for this when digging into ASP.NET Core source code and other samples online.
  • Radial Gauge Control In UWPNov 15, 2017. Reading this article, you will learn how to use Radial Gauge Control in Universal Windows Apps development with XAML and Visual C#.
  • Three Places To Manage Modern / Classic Experience For Lists And LibrariesNov 15, 2017. This article explains how to manage the classic experience and modern experience for SharePoint Online Lists & Libraries
  • Steps To Configure Xamarin.Android Emulator Performance - Part TwoNov 14, 2017. Xamarin is a cross-platform development tool. With Xamarin, you can use C# for iOS, Android, and Universal Windows apps. And with Xamarin Forms, interface design for all three platforms can be accomplished within its XAML-based framework.
  • Automating Code Deployment With Azure And GitHubNov 13, 2017. In this article you will learn about how to use ‘App Services’ and exploit Github’s source code management functionalities and version control in order to automate the deployment of your software and maintain a record of prior changes in order to mitigate extra effort in pushing to production.
  • Xamarin.Android - Create A Chat App Using ASP.NET And SignalRNov 13, 2017. Today, I demonstrate you how to build a signalr chat client application using asp.net and xamarin.android with azure.
  • Xamarin.Forms - Login Flow APPNov 13, 2017. In this article, we will discuss how to create login system in Xamarin.Forms using Visual Studio 2017
  • OrbitView Control In UWPNov 11, 2017. Reading this article, you will learn how to use OrbitView Control in Universal Windows Apps development with XAML and Visual C#.
  • Introduction To Serverless Architecture In AzureNov 11, 2017. In this article, we will see how to create logic apps in Azure.
  • Introduction To Bot Service In AzureNov 10, 2017. Bot used as an app that helps users interact in a conventional way. It may be as simple as basic pattern matching with a response or it may be sophisticated handling the artificial techniques with complex conversational state and integration to existing business services.
  • Introduction To Xamarin.Android Using C# - Part OneNov 10, 2017. Xamarin.Android will create native Android applications using modern language (C#), .NET Base Class Library Visual Studio. Xamarin is a cross-platform development tool. It solves dilemmas many developers face when developing cross-platform apps: separate coding languages and UI paradigms. With Xamarin, you can use C# for iOS, Android, and Universal Windows apps. And with Xamarin Forms, interface design for all three platforms can be accomplished within its XAML-based framework.
  • Loading Control In UWPNov 10, 2017. Reading this article, you will learn how to use Loading Control in Universal Windows Apps development with XAML and Visual C#.
  • DropShadowPanel Control In UWPNov 09, 2017. Reading this article, you can learn how to use DropShadowPanel Control in Universal Windows Apps development with XAML and Visual C#.
  • How To Create Logic App From Template In AzureNov 09, 2017. Azure Logic Apps is a fully managed integration Platform as a service which provide a way to automate the workflows and business processes. You could easily integrate across different services in cloud and on-premise through connectors. In this article you will see how to create logic app from template which will create a new item in SharePoint Online list when a new tweet appears with text as “SharePoint”, #SharePoint, O365 or Azure.
  • Angular Basics and Quickstart with CLINov 09, 2017. Imagine what it would be to manually add the configuration files required to bootstrap an Angular 4 application. It is painful, right? For beginners, it might become tedious to declare all these files and manually configure all these files to bootstrap the app. It wouldn't be a good idea to set up the configuration things rather than focus on the framework and its usage. Even for the advanced developer, it might not be a great way to do all these things manually. So, Angular CLI is the solution here
  • Expander Control In UWPNov 09, 2017. Reading this article, you can learn how to use Expander Control in Universal Windows Apps development with XAML and Visual C#.
  • Create A Flash Light App In Xamarin.Android Using Visual StudioNov 08, 2017. Here it goes, My friend receive Samsung mobile phone few month ago. She like it in particular, yet one thing that it doesn't accompany is the toolbox for fundamental utilities. One of them is the spotlight application that triggers the gadget to enact or deactivate the electric lamp as required. Android supports you to have Camera API devoured in your application (all things considered, electric lamp is given to photographs or recordings and not as a floodlight). Anyway, I was believing that I ought to get an application from Play Store, correct? No! Despite the fact that it would give me an "exquisite" answer for my spotlight issue, yet shouldn't something be said about the armed force of ad I should experience, or the hazy UI of the application. So I figured I should manufacture an application for herself to have the capacity to trigger the spotlight on or off.
  • How To Create A Blank Logic App In AzureNov 07, 2017. Azure Logic Apps is a fully managed integration platform as a service which provides a way to automate the workflows and business processes. You could easily integrate across different services in the cloud and on-premise through connectors. In this article you will see how to create a blank logic app which will send an email to a Gmail account when a new tweet is posted with the text “SharePoint” or #SharePoint.
  • Alphabets to Numbers Translator For Calling In Xamarin.AndroidNov 07, 2017. In this article, we will learn how to build Call Translator App for Xamarin Android. This is a simple app for learning some basics for beginners and you can also create it in Android Studio but I like to make it in Visual Studio, therefore I developed it in Xamarin.
  • AI-Assistant Devices Create Opportunities For DevelopersNov 06, 2017. Market for AI-assistant app and skill developers will grow.
  • Power BI And Excel File As Data SourceNov 06, 2017. Though we have several options for data sources to connect with Power BI in this blog, I am going to write about how we can use Excel data with Power BI and how to refresh the report when Excel data is changed.
  • Carousel Control In UWPNov 06, 2017. Reading this article, you can learn how to use Carousel Control in Universal Windows Apps development with XAML and Visual C#.
  • Retrieve User Profile Properties Using SPFx And PnP JS In SharePoint OnlineNov 05, 2017. SharePoint Framework is the new development model in which a lot of work has been going on since it went to General Availability on Feb 23, 2017. It is a page and web part model that provides full support for client-side SharePoint development, easy integration with SharePoint data and support for open source tooling. With the SharePoint Framework, you can use modern web technologies and tools in your preferred development environment to build productive experiences and apps in SharePoint.
  • Introduction To Bing Search API In AzureNov 05, 2017. Bing Search API adds intelligent search to your app and also it contains billions of web pages, videos, images. The best feature is that the results can be automatically customized to your user’s locations or markets.
  • PersonPicture Control In UWPNov 03, 2017. Reading this article, you can learn how to use PersonPicture Control in Universal Windows Apps development with XAML and Visual C#.
  • How To Move Site Or Subsite To Another Site Or Subsite In SharePoint OnlineNov 01, 2017. Sometimes, there is a situation in which we need to move one subsite to another subsite. We can move one subsite to another subsite using Site Manager in sharePoint Online.Here I explained all the steps in detail.
  • How To Connect The Outlook Mail To Excel With Microsoft FlowOct 31, 2017. This article helps you to learn how to create a Flow between the Outlook Mail and Excel Spreadsheet.
  • SystemDataPaths In UWP (Windows 10 Fall Creators Update Features)Oct 31, 2017. This article explains about how to get system , app , user based path information. This SystemDataPaths, UserDataPaths, AppDataPaths class will be supported on Windows 10 Fall creators updated version build or greater and Windows 10 SDK 16999.
  • Useful URL Shortcuts For SharePoint Online - Part TwoOct 29, 2017. In this second part of URL shortcuts, I am going to write some useful URLs which will help developers or administrators perform their daily tasks in a very easy manner. As a developer these shortcuts are very useful to us. These URL shortcuts make our work faster. This article covers eight shortcut URL which we can use in our daily practice.
  • Image Copy And Paste Using Clipboard In UWPOct 29, 2017. Reading this article, you can learn how to perform Copy and paste Images using clipboard in Universal Windows Apps development with XAML and Visual C#.
  • Copy And Paste Text Content Using Clipboard In UWP With XAML And C#Oct 27, 2017. Reading this article, you will learn how to copy and paste the text content using clipboard in Universal Windows Apps development with XAML and Visual C#.
  • Useful URL Shortcuts For SharePoint Online - Part OneOct 26, 2017. In this article, I am going to write some useful URLs which will help developers or administrators perform their daily tasks in a very easy manner.
  • How To Read CSV File In ASP.NET With Example C# and VB.NETOct 26, 2017. In this articleI'll explain a way to upload, read/browse and show CSV file (Text File) information in ASP.Net GridView using C# and VB.Net.
  • Azure Service Bus - Peek-Lock A Message From Queue Using Azure Logic AppsOct 26, 2017. In this article, we will take a look at how you can peek-lock on a message from a Service Bus Queue without actually reading the message from the queue.
  • Develop Multi-Platform And Connected Apps And Deploy Them On AzureOct 26, 2017. PaaS allows companies and developers to focus only on applications and services and not infrastructure. PaaS provides all the services needed to create, code, deploy and run websites, mobile services, and more.
  • Setting Or Retrieving Geotag In Media File In UWP With XAML And C#Oct 25, 2017. Reading this article, you can learn how to set or retrieve Geotagging in Media File in Universal Windows Apps development with XAML and Visual C#.
  • Security Credential Picker In UWP With XAML And C#Oct 24, 2017. Reading this article, we can learn how to use Credential Picker in Universal Windows Apps development with XAML and Visual C#.
  • Missing 'Manage Delegates' Option In PWA Setting In Project Server 2016Oct 23, 2017. In this article, we will be fixing the issue Missing 'Manage Delegates' option in PWA Setting.
  • Enable And Disable Wi-Fi In Android Application Using Android StudioOct 20, 2017. In this article, I will show you how to Enable and Disable WI-FI in android App using Android studio. The information that an application can access includes connected network's link speed, IP address, negotiation state, other networks information. Applications can also scan, add, save, terminate and initiate Wi-Fi connections.
  • Running Business Rule Only On Record CreateOct 16, 2017. We know that business rules are executed on form load and on change of the associated field, which means if we have business rule for any entity it will fire for new record as well for existing records when form loads.
  • Read Excel File In C# WinFormOct 13, 2017. Here we are going to learn to read Excel files in C# windows form applications.
  • Getting Started With SharePoint Framework For SharePoint 2016 On-PremisesOct 12, 2017. Once you have installed and upgraded the September 2017 Public Update for SharePoint 2016, you will be able to upload and deploy SharePoint Framework packages that contain web parts via the SharePoint App Catalog just as you would with SharePoint Add-ins.
  • Understanding Bing Search API In AzureOct 12, 2017. The Bing Search API adds intelligent search to your app, combing hundreds of billions of webpages, images, videos, and news to provide relevant results with no ad requirements. The results can be automatically customized to your users' locations or markets, increasing relevancy by staying local.
  • Understanding Face API In AzureOct 11, 2017. Add facial recognition capabilities to your app with the Face API. State-of-the-art algorithms detect human faces in images, opening a range of facial capabilities to your apps. Face detection can also identify attributes, including face landmarks (nose, eyes, etc.), gender, age, and other machine-predicted facial features.
  • How To Hide "Edit" Option In A List Or Allow It Only For Admins In SharePoint OnlineOct 11, 2017. In this article, I will discuss how to hide the “Edit” option in a list.
  • Excel To XML Using LINQOct 11, 2017. In this article we will show you the easiest way to convert Excel data into Xml files. There is a certain way to convert Excel file to Xml, for example using Excel Library (Com Component)
  • Azure App Service - Deployment SlotOct 08, 2017. Azure makes it easy, to create deployment slots for App Services. It’s available in the Standard or Premium App Service plan mode. Deployment slots are actually live apps with their own hostnames. App content and configurations elements can be swapped between two deployment slots, including the production slot.
  • Sending Bot Reply Message With Attachment Using Bot FrameworkOct 07, 2017. The Bot Framework enables you to build bots that support different types of interactions with users. You can design conversations in your bot to be freeform. Your bot can also have more guided interactions where it provides the user choices or actions. The conversation can use simple text strings, the message with an attachment like the image, File (pdf, word, excel, ppt), mp3, Video or more complex rich cards.
  • Getting Started With ASP.NET Core MVC Apps Using VS CodeOct 05, 2017. In this article, we will discuss how we can create a HelloWorld app with ASP.NET Core 2.0 using Visual Studio Code. We will learn how to create an ASP.NET Core MVC application, how to create new Controller, how to create new View, and how to run the HelloWorld app etc.
  • Xamarin.Forms - Create Message Center AppOct 05, 2017. Xamarin Forms Platform using create message center application. This article demonstrates how to create Message Center Application C# and XAML in Xamarin Forms.
  • CRUD Operation With ASP.NET Core MVC Web App Using ADO.NETOct 05, 2017. In this article, I am going to explain how to create a MVC web application in ASP.NET Core 2.0 using ADO.NET.
  • Change Site Collection URL, Title, Logo In SharePoint 2013 Using PowerShell Commands, Back Up And Restore OptionOct 05, 2017. In this article I have discussed about how to change the site collection URL, title & logo in SharePoint 2013. Suppose in your company you have already created your site collection & customized everything but later your company decided to change the Site URL & title as well.
  • How To Change User Language Settings In SharePointOct 04, 2017. In this article, I will discuss how to change language settings for a particular user using two ways. When you create a site , you also specify user language setting such as Time Zone, local display for numbers, dates, and time, sort order, calendar type, work week, and time format (12 or 24 hour) settings in both SharePoint On premise and Online.
  • Create Sensor Android App Using Android StudioOct 03, 2017. In this article, I will show you how to create a Sensor Android App using Android studio. we are going to create a sensor application that changes the background color of an activity when a device is shaken.
  • Read Data From Excel With Preview In ASP.NET MVC Using AngularOct 03, 2017. In this article we will see how to Read data from excel and show preview and after we can update to database with Asp.net Mvc using Angular.
  • Creating Custom Gulp Tasks In SPFx SolutionsOct 03, 2017. Let us see how to create and test the gulp tasks in the SharePoint Framework solutions.
  • Migrate SharePoint On-Premises Content To SharePoint Online Using SPO APIOct 02, 2017. Below is the step by step SharePoint Online PowerShell cmdlets to migrate the content. It requires minimal CSOM (Client object model) call to avoid the threshold. It leverages a temporary Azure Blob Storage container to hold the content and Azure Queue, which schedule parallel jobs.
  • Executing Exchange Online PowerShell Command Through SharePoint Online PowerShellOct 02, 2017. For Office 365 administrators there are lists of Exchange Online PowerShell cmdlets available. We can execute these cmdlets through SharePoint Online Management Shell or Windows PowerShell by creating remote PowerShell session with Exchange Online. In this article I’ll explain how to create remote PowerShell session to Exchange Online and then execute Exchange Online PowerShell cmdlets.
  • Manifest File In Progressive Web AppOct 01, 2017. In this article we will learn what the purpose of manifest.json file in a Progressive Web Application is.
  • Get Started With Cortana DevelopmentSep 29, 2017. Cortana is Microsoft's AI assistant built-in to Windows 10 devices. Cortana now will also be available via speaker. C# and .NET developers can start building Cortana skills using Visual Studio 2017. Cortana can use your bots, connect with services, work with websites, and even be used to build standalone apps, similar to Alexa. Cortana standalone apps are called Cortana Skills.
  • SharePoint 2013 - Converting GMT/UTC Time To Local Time In XSLT For Rendering RSS Feed ResultsSep 29, 2017. Recently, I came across the requirement where the date coming from RSS feed which is in GMT format needed to be converted to local time and displayed in the required format.
  • Sample Document Management System In SharePoint OnlineSep 28, 2017. In this article, we will discuss about a simple document management system sample in SharePoint Online. With O365 we can use sites to share & collaborate documents at any time on any device. Default Site in O365 is team site. For business we can customize our sites & use it for internet. By default Team sites has a logo, title, Navigation Links, Started tiles, Newsfeed, documents & notebook for collaboration. Please refer below screenshot.
  • RatingBar Android App Using Android StudioSep 27, 2017. Android RatingBar can be used to get a rating from the user. The rating returns a floating-point number. It may be 2.0, 3.5, 4.0 etc. Android RatingBar displays the rating in stars. In this article, I will show you how to create RatingBar Android App using Android Studio.
  • SharePoint 2016/2013 - Event Log Monitoring By PowerShell AutomationSep 27, 2017. This article is based on the requirement I recently encountered where I was required to monitor a specific exception type and if it occurred the Admins needed to be notified at the same time.
  • Build Desktop Chat App With Angular 2 And Electron - Part OneSep 26, 2017. In this article series, we are going to develop a desktop chat application using Angular 2 and Electron. In this part, we are going to set up an Angular 2 application with electron. We will extend this application in future article parts to use it as chat window.
  • What's New In XamarinSep 26, 2017. Xamarin enables developers to build native iOS, Android, and Windows mobile apps using C# and .NET.
  • SharePoint 2016/2013 - Exploring Client Side People Picker ControlSep 26, 2017. In this demo, I will be discussing the implementation details of the Client Side People Picker Control in Production Scenarios.
  • Understanding Gulp Tasks In SharePoint Framework SolutionsSep 24, 2017. Let us look deeply into the Gulp tasks we use in SharePoint framework solutions. Gulp helps in automating the manual tasks done in a solution. Say for example, when you create SharePoint framework solution, you try to test the web parts using the gulp tasks. The tasks are defined using gulpfile.js present in the SPFx solution.
  • Auto-Complete Text View Android App Using Android StudioSep 23, 2017. In this article, I will show you how to create an Auto Complete Text view Android App using Android studio.
  • Toggle Button Android App Using Android StudioSep 23, 2017. Android Toggle Button can be used to display checked/unchecked (On/Off) state on the button. It is beneficial if user have to change the setting between two states. It can be used to On/Off Sound, Wifi, Bluetooth etc. In this article, I will show you how to create Toggle Button android App using android studio.
  • Azure Logic Apps Integration With Microsoft TeamsSep 22, 2017. In this article, you will see how you can use Azure Logic Apps to get your RSS Feeds converted into short links and get them delivered directly into your Microsoft Teams channel and mailbox.
  • Store Images In App Directory In Xamarin iOSSep 21, 2017. In this article, you will learn how to store images in the App Directory in Xamarin iOS, using Xamarin Studio.
  • Create SMS Android App Using Android StudioSep 21, 2017. In this article, I will show you how to create a pop up menu Android App using Android Studio. SMS stands for Short Message Service and is also commonly referred to as a "text message". With a SMS, you can send a message of up to 160 characters to another device. Longer messages will automatically be split up into several parts. Most cell phones support this type of text messaging.
  • Adding Check Box Functionality In An Android App Using Android StudioSep 21, 2017. In this article, I will show you how to create am Android app using Android Studio. Android Checkbox is a type of two state button, either checked or unchecked. There can be a lot of usage of checkboxes. For example, it can be used to know the hobby of the user, activate/deactivate the specific action etc.
  • Create Instant Alarm Android App Using Android StudioSep 20, 2017. In this article, I will show you how to create an Instant Alarm Android App using Android studio.
  • Pop Up Menu Android ApplicationSep 20, 2017. In this article, I will show you how to create a pop up menu Android App using Android studio. Android Popup Menu displays the menu below the anchor text if space is available otherwise above the anchor text. It disappears if you click outside the popup menu.
  • Gallery Android App Using Android StudioSep 19, 2017. In this article, I will show you how to create an Android App using Android studio. Gallery is either in a building or on the internet, where photographs are on display.
  • What Is New In iOS 11?Sep 19, 2017. iOS 11 sets a new standard for the world’s most advanced mobile operating system. Your apps can now become more intelligent using the power of machine learning with Core ML. You can create incredible augmented reality experiences with ARKit. And you can deliver a more unified and immersive user experience with new multitasking features, including drag and drop for iPad, the new Files app, new camera APIs, new SiriKit domains, Apple Music integration, and more
  • Fetch User Details And Profile Picture From Person Or Group Field Using REST APISep 18, 2017. In one of my projects (on Office 365) I have a requirement to scroll key contacts of a project with the use's Full Name, Department, Job Title, Phone (Work/ Mobile) and Picture URL. Since all contacts are internal employees I don’t have to input user details, I just need a person and group field in a list to capture the user.
  • Missing Security Section In PWA Settings In Project Server 2016Sep 18, 2017. In this article, we will discuss and solve the issue of Missing Security Setting in PWA Settings in Project Server 2016 / 2013.
  • Start The App In Windows Startup In UWP (Windows 10 Fall Creators Update Features)Sep 17, 2017. A long-awaited feature (other features are LaunchApp, Restart App) has come to Universal Windows Programming i.e. we can run our application on Windows startup (User log in to the system), Previously we had done some workaround to run the app in windows startup, now it's time to say good bye to the workaround.
  • App That Changes Background And Audio Player In Android, Using Android StudioSep 17, 2017. In this article, I will show you how to change background and audio player Android App using android studio.
  • Use Of Slicer In Power BI And Its Integration In SharePoint OnlineSep 17, 2017. Power BI is a Microsoft tool which provides many types of Visual Reports such as Clustered Column Chart, Clustered Bar Chart, Pie Chart,Donut Chart,Gauge,R script Visual, Tree map, Filled Map, Waterfall Chart, Scatter Chart, Slicer and many more. Among these I will be demonstrating a slicer which can be used to filter a tabular report and other reports.
  • Using MPMoviePlayer In Xamarin iOSSep 15, 2017. Xamarin is a platform to develop cross-platform and multi-platform apps (for example, Windows Phone, Android, iOS). In Xamarin platform, the code sharing concept is used. In Xamarin Studio, Visual Studio is also available.
  • Step By Step Procedure To Create A Microsoft FlowSep 14, 2017. Microsoft Flow is a part of Office 365 suite which is a cloud-based software tool that allows users to create an automated workflow across multiple applications and services without the need for developer help. Microsoft flows is built on top logic app engine. But as this app is built for targeting business personnel, the total process is UI based. To create a flow, the user specifies what action should take place when a specific event occurs.
  • SharePoint Permission Mode Vs Project Permission Mode In Project Server 2016 / 2013Sep 14, 2017. In this article, we will discuss the Permission Modes in Project Server 2016 / 2013.

About Online-apps-for-Excel-2013

NA
File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!