Skip to content

Instantly share code, notes, and snippets.

View devmnj's full-sized avatar
💭
Exploring Algos

Manoj AP devmnj

💭
Exploring Algos
View GitHub Profile
@devmnj
devmnj / word-doc.cs
Created January 12, 2023 11:20
Create word document using Open XML SDK in C#.net
public static StyleDefinitionsPart AddStylesPartToPackage2(WordprocessingDocument doc)
{
StyleDefinitionsPart part;
part = doc.MainDocumentPart.AddNewPart<StyleDefinitionsPart>();
Styles root = new Styles();
root.Save(part);
return part;
}
// Create a new style with the specified styleid and stylename and add it to the specified
@devmnj
devmnj / closed-spreadsheet.cs
Created January 12, 2023 11:16
Crreate a spreadsheet locally in C# using Closex XML, a wrapper around open xml sdk
var workbook = new XLWorkbook();
var ws = workbook.Worksheets.Add("TRIAL");
var columnFromWorksheet = ws.Column(1);
columnFromWorksheet.Cell(1).Value = "TRIAL BALANCE";
var columnFromRange = ws.Range("A1:K2").Merge().Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right;
workbook.SaveAs("closedxl.xlsx");
@devmnj
devmnj / spreasheet.cs
Created January 12, 2023 11:13
Create a spread sheet with custom styles using Open XML DSK
using (SpreadsheetDocument document = SpreadsheetDocument.Create("somefile.xls", SpreadsheetDocumentType.Workbook))
{
WorkbookPart workbookPart = document.AddWorkbookPart();
workbookPart.Workbook = new DocumentFormat.OpenXml.Spreadsheet.Workbook();
WorksheetPart worksheetPart = workbookPart.AddNewPart<WorksheetPart>();
WorkbookStylesPart sp = workbookPart.AddNewPart<WorkbookStylesPart>();
sp.Stylesheet = new DocumentFormat.OpenXml.Spreadsheet.Stylesheet();
Stylesheet stylesheet = sp.Stylesheet;
stylesheet.Fonts = new DocumentFormat.OpenXml.Spreadsheet.Fonts();
@devmnj
devmnj / schema
Created December 4, 2022 12:19
Sanity Preview in a Sanity custom type
preview:{
select:{
title:'name',
imageUrl: 'avatar'
},prepare(selection){
const {title,imageUrl} =selection;
return{
title:title,
media:<img src={imageUrl} alt=''/>
}
@devmnj
devmnj / CommentBox.jsx
Created November 27, 2022 04:31
Sanity CommentBox - Nextjs 13
'use client'
/* eslint-disable @next/next/no-img-element */
import React, { useState } from 'react'
import client from "../lib/sanity";
export default function CommentBox(props: { post: any; }) {
const [name, setName] = useState('')
const [email, setEmail] = useState('')
const [comment, setComment] = useState('')
@devmnj
devmnj / cog-loading-animation.markdown
Created November 1, 2022 04:13
Cog loading animation
@devmnj
devmnj / index.html
Created November 1, 2022 04:12
Material Design Preloader
<header>
<div aria-busy="true" aria-label="Loading, please wait." role="progressbar"></div>
</header>
<main role="main">
<img src="https://www.google.com/inbox/assets/images/intro/intro-logo.png" width="100" alt="" />
<h1>Material Design Preloader</h1>
<p>A CSS only solution that recreates the Material Design preloader; or, who needs jQuery anyway?</p>
<p>You should set <code>aria-busy</code> to <code>false</code> when your stuff is loaded.
</main>
@devmnj
devmnj / css-gears.markdown
Created November 1, 2022 04:11
CSS Gears

CSS Gears

I made these for my new portfolio site. You might be able to use this as a loading animation or something like that. I had this demo up here before but I think codepen ate it. They do look pretty tasty.

Forked from Alex Tebbs's Pen CSS Gears.

A Pen by Karafizi Arthur on CodePen.

License.

@devmnj
devmnj / App.svelte
Created October 31, 2022 11:58
Styling inner tag in @htm - Svelte
<div class=" mb-1 text-lg">
<style>
a:hover {
color: orange;
}
</style>
{@html html}
</div>
@devmnj
devmnj / analytic.svelte
Last active October 31, 2022 11:56
Svelete Analytic Component
Place the component in +layout.svelte
<script lang="ts">
import { page } from '$app/stores'
$: {
if (typeof gtag !== 'undefined') {
gtag('config', 'MEASUREMENT_ID', {
page_title: document.title,
page_path: $page.url.pathname,
})